{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "5ce90cbc",
   "metadata": {},
   "source": [
    "* 城市：'全国'、 '北京、 '上海'、 '天津'、 '重庆'、 '广州'、'深圳'、 '苏州'、 '南京'、 '杭州'、 '大连'、'成都'、 '武汉'、 '西安'\n",
    "* 关键词：不限制\n",
    "* 工作经验：'应届生'、 '实习生'、 '1年以内'、 '1-3年'、'3-5年'、 '5-10年'、'10年以上'\n",
    "* 公司规模：1-49人、50-99人、100-499人、500-999人、1000-2000人、2000-5000人、5000-10000人、10000人以上"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "6ac5b3c7",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "请输入城市：广州\n",
      "请输入职位：产品经理\n",
      "这是第1页，接下来将先等待6秒...然后以继续抓取\n",
      "这是第2页，接下来将先等待3秒...然后以继续抓取\n",
      "这是第3页，接下来将先等待9秒...然后以继续抓取\n",
      "这是第4页，接下来将先等待9秒...然后以继续抓取\n",
      "这是第5页，接下来将先等待6秒...然后以继续抓取\n",
      "这是第6页，接下来将先等待6秒...然后以继续抓取\n",
      "这是第7页，接下来将先等待10秒...然后以继续抓取\n",
      "这是第8页，接下来将先等待9秒...然后以继续抓取\n",
      "这是第9页，接下来将先等待7秒...然后以继续抓取\n",
      "这是第10页，接下来将先等待10秒...然后以继续抓取\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>dataInfo</th>\n",
       "      <th>dataParams</th>\n",
       "      <th>comp.compId</th>\n",
       "      <th>comp.compName</th>\n",
       "      <th>comp.compLogo</th>\n",
       "      <th>comp.compScale</th>\n",
       "      <th>comp.compIndustry</th>\n",
       "      <th>comp.link</th>\n",
       "      <th>job.labels</th>\n",
       "      <th>job.title</th>\n",
       "      <th>...</th>\n",
       "      <th>job.link</th>\n",
       "      <th>job.dataPromId</th>\n",
       "      <th>recruiter.imId</th>\n",
       "      <th>recruiter.imUserType</th>\n",
       "      <th>recruiter.chatted</th>\n",
       "      <th>recruiter.recruiterName</th>\n",
       "      <th>recruiter.recruiterTitle</th>\n",
       "      <th>recruiter.recruiterId</th>\n",
       "      <th>recruiter.recruiterPhoto</th>\n",
       "      <th>comp.compStage</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>%7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...</td>\n",
       "      <td>{\"jobKind\":\"2\",\"jobId\":\"22426839\",\"userId\":\"6f...</td>\n",
       "      <td>1876210.0</td>\n",
       "      <td>广州迪柯尼服饰股份有限公司</td>\n",
       "      <td>5bfe9ef274719d2aa34bac8b03a.png</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>服装/纺织/皮革</td>\n",
       "      <td>https://www.liepin.com/company/1876210/</td>\n",
       "      <td>[商品企划, 数据分析, 产品规划, 波段管理, 成本分析]</td>\n",
       "      <td>商品企划经理</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/job/1922426839.shtml</td>\n",
       "      <td>d_sfrom=search_prime&amp;d_ckId=null&amp;d_curPage=0&amp;d...</td>\n",
       "      <td>492a74489f2f8a893eaad1f295204b5b</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>刘女士</td>\n",
       "      <td>招聘者</td>\n",
       "      <td>6f37571c13bed9fc606640b0edee6eee</td>\n",
       "      <td>5f8f9863f6d1ab58476f246a08u.jpg</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>%7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...</td>\n",
       "      <td>{\"jobKind\":\"2\",\"jobId\":\"57437937\",\"userId\":\"d9...</td>\n",
       "      <td>7891767.0</td>\n",
       "      <td>上海贝锐信息科技股份有限公司</td>\n",
       "      <td>64a5494ed5b3d376c070330502u.png</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>https://www.liepin.com/company/7891767/</td>\n",
       "      <td>[商业产品, 客户端产品, 增长产品, SaaS系统, 计算机软件, 产品规划, 团队管理,...</td>\n",
       "      <td>产品经理</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/job/1957437937.shtml</td>\n",
       "      <td>d_sfrom=search_prime&amp;d_ckId=null&amp;d_curPage=0&amp;d...</td>\n",
       "      <td>e9d800aebed3ce4e67766a03c68ce883</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>张先生</td>\n",
       "      <td>hr</td>\n",
       "      <td>d938dfd61b82bb63e0d7e82a5823cab2</td>\n",
       "      <td>5f8f986c79c7cc70efbf36c808u.jpg</td>\n",
       "      <td>B轮</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>%7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...</td>\n",
       "      <td>{\"jobKind\":\"2\",\"jobId\":\"51997333\",\"userId\":\"d9...</td>\n",
       "      <td>7891767.0</td>\n",
       "      <td>上海贝锐信息科技股份有限公司</td>\n",
       "      <td>64a5494ed5b3d376c070330502u.png</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>https://www.liepin.com/company/7891767/</td>\n",
       "      <td>[SaaS产品, 商业产品, 增长产品, SaaS系统, CRM系统, 企业服务, 科研/技...</td>\n",
       "      <td>产品经理（B端）</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/job/1951997333.shtml</td>\n",
       "      <td>d_sfrom=search_prime&amp;d_ckId=null&amp;d_curPage=0&amp;d...</td>\n",
       "      <td>e9d800aebed3ce4e67766a03c68ce883</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>张先生</td>\n",
       "      <td>hr</td>\n",
       "      <td>d938dfd61b82bb63e0d7e82a5823cab2</td>\n",
       "      <td>5f8f986c79c7cc70efbf36c808u.jpg</td>\n",
       "      <td>B轮</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>%7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...</td>\n",
       "      <td>{\"jobKind\":\"2\",\"jobId\":\"50965433\",\"userId\":\"14...</td>\n",
       "      <td>8112968.0</td>\n",
       "      <td>仙婷集团</td>\n",
       "      <td>6274ee6d04a5ff469b10880402u.png</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>贸易/进出口</td>\n",
       "      <td>https://www.liepin.com/company/8112968/</td>\n",
       "      <td>[英语, 市场推广, 市场拓展, 渠道策划, 市场策划, 市场调研分析, 乙方公司背景, t...</td>\n",
       "      <td>产品经理（化妆品原料）/Product Manager</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/job/1950965433.shtml</td>\n",
       "      <td>d_sfrom=search_prime&amp;d_ckId=null&amp;d_curPage=0&amp;d...</td>\n",
       "      <td>0ce6f53a162e27cc9427b88c78d2ff1f</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>吴女士</td>\n",
       "      <td>HR Officer</td>\n",
       "      <td>14799e1bef289c70aa9b550257de7ea8</td>\n",
       "      <td>5f8f98648dbe6273dcf8515508u.jpg</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>%7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...</td>\n",
       "      <td>{\"jobKind\":\"2\",\"jobId\":\"55703639\",\"userId\":\"7d...</td>\n",
       "      <td>9491766.0</td>\n",
       "      <td>文远知行WeRide</td>\n",
       "      <td>60a497de907306298575785f03u.png</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>人工智能</td>\n",
       "      <td>https://www.liepin.com/company/9491766/</td>\n",
       "      <td>[工具产品, 安全产品, 客户端产品, 交通/运输/物流, 汽车行业, 自动驾驶, 产品优化...</td>\n",
       "      <td>自动驾驶产品经理（PM）</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/job/1955703639.shtml</td>\n",
       "      <td>d_sfrom=search_prime&amp;d_ckId=null&amp;d_curPage=0&amp;d...</td>\n",
       "      <td>e2b135092ee70a2ae950a599d250d4ad</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>侯先生</td>\n",
       "      <td>HRBP</td>\n",
       "      <td>7da08eb2dc102f58400ecda04a611db0</td>\n",
       "      <td>5f8f986bdfb13a7dee342f2108u.jpg</td>\n",
       "      <td>D轮</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>%7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...</td>\n",
       "      <td>{\"imId\":\"ddff081e3f640fb94383db9bf147ecbd\",\"im...</td>\n",
       "      <td>8062150.0</td>\n",
       "      <td>博纳德集团</td>\n",
       "      <td>60d96977208b48306211556005u.png</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>https://www.liepin.com/company/8062150/</td>\n",
       "      <td>[SaaS产品, to B, 人事系统, HRM系统, HR模块, 人才发展, 培训, 招聘...</td>\n",
       "      <td>产品经理（人事系统）</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/job/1961993579.shtml</td>\n",
       "      <td>d_sfrom=search_prime&amp;d_ckId=null&amp;d_curPage=9&amp;d...</td>\n",
       "      <td>ddff081e3f640fb94383db9bf147ecbd</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>唐女士</td>\n",
       "      <td>高级招聘经理</td>\n",
       "      <td>af74d747eb8fff70ad63c04ba6f2e71b</td>\n",
       "      <td>5f8f986779c7cc70efbf36c008u.jpg</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>%7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...</td>\n",
       "      <td>{\"imId\":\"1c69fb72e466e3314ebbef01db417cf0\",\"im...</td>\n",
       "      <td>13531199.0</td>\n",
       "      <td>火猩未来</td>\n",
       "      <td>647e91b1274ac74c74e562d503u.png</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>电子商务</td>\n",
       "      <td>https://www.liepin.com/company/13531199/</td>\n",
       "      <td>[小家电, 厨卫电器, 保健电器, 取暖电器, 制冷电器, 个护电器, 饮水电器, 生命周期...</td>\n",
       "      <td>资深硬件产品经理</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/job/1958992735.shtml</td>\n",
       "      <td>d_sfrom=search_prime&amp;d_ckId=null&amp;d_curPage=9&amp;d...</td>\n",
       "      <td>1c69fb72e466e3314ebbef01db417cf0</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>李女士</td>\n",
       "      <td>招聘专员</td>\n",
       "      <td>083bf20a22f9eb25f205ad6f39096483</td>\n",
       "      <td>5f8f9866dfb13a7dee342f1808u.jpg</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>%7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...</td>\n",
       "      <td>{\"imId\":\"ab96327731ebf716f279285841cea99b\",\"im...</td>\n",
       "      <td>9092472.0</td>\n",
       "      <td>梅州客商银行股份有限公司</td>\n",
       "      <td>5bfe92a274719d9f609a755f03a.png</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>银行</td>\n",
       "      <td>https://www.liepin.com/company/9092472/</td>\n",
       "      <td>[金融产品, 金融行业, 电子产品及配件, 产品优化, 用户研究, 产品规划]</td>\n",
       "      <td>网络金融部产品经理</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/job/1956981809.shtml</td>\n",
       "      <td>d_sfrom=search_prime&amp;d_ckId=null&amp;d_curPage=9&amp;d...</td>\n",
       "      <td>ab96327731ebf716f279285841cea99b</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>李女士</td>\n",
       "      <td>人事主管hrbp</td>\n",
       "      <td>3b9b7106ae3c037eeecc0881016258b0</td>\n",
       "      <td>5f8f9866dfb13a7dee342f1808u.jpg</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>%7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...</td>\n",
       "      <td>{\"imId\":\"7c51dc9ff303b3c9fa40e259a967f7de\",\"im...</td>\n",
       "      <td>8706847.0</td>\n",
       "      <td>SHEIN</td>\n",
       "      <td>5c64c511261c45f22d50d39303u.png</td>\n",
       "      <td>5000-10000人</td>\n",
       "      <td>互联网</td>\n",
       "      <td>https://www.liepin.com/company/8706847/</td>\n",
       "      <td>[ppt, 架构设计, axure, visio, xmind, 数据分析]</td>\n",
       "      <td>高级WMS产品经理 (MJ003186)</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/job/1942074303.shtml</td>\n",
       "      <td>d_sfrom=search_prime&amp;d_ckId=null&amp;d_curPage=9&amp;d...</td>\n",
       "      <td>7c51dc9ff303b3c9fa40e259a967f7de</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>贺女士</td>\n",
       "      <td>助理顾问(AC)</td>\n",
       "      <td>9294a5a1e3837c5ebb372434d8d59956</td>\n",
       "      <td>5f8f9863f6d1ab58476f246a08u.jpg</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>%7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...</td>\n",
       "      <td>{\"imId\":\"791f1b5440a26d36cd74bb959a88946e\",\"im...</td>\n",
       "      <td>8062150.0</td>\n",
       "      <td>博纳德集团</td>\n",
       "      <td>60d96977208b48306211556005u.png</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>https://www.liepin.com/company/8062150/</td>\n",
       "      <td>[后台产品, 数据产品, IT互联网, to B, 产品设计, 产品规划, 用户研究]</td>\n",
       "      <td>HRM产品经理</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/job/1962102851.shtml</td>\n",
       "      <td>d_sfrom=search_prime&amp;d_ckId=null&amp;d_curPage=9&amp;d...</td>\n",
       "      <td>791f1b5440a26d36cd74bb959a88946e</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>植先生</td>\n",
       "      <td>高级招聘顾问</td>\n",
       "      <td>a7b48e55484d5f5cdcc3f8271f977e46</td>\n",
       "      <td>5f8f986aea60860b75384fab08u.jpg</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>400 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             dataInfo  \\\n",
       "0   %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       "1   %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       "2   %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       "3   %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       "4   %7B%22sfrom%22%3A%22search_job_pc%22%2C%22jobK...   \n",
       "..                                                ...   \n",
       "35  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       "36  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       "37  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       "38  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       "39  %7B%22pageSize%22%3A%2240%22%2C%22curPage%22%3...   \n",
       "\n",
       "                                           dataParams  comp.compId  \\\n",
       "0   {\"jobKind\":\"2\",\"jobId\":\"22426839\",\"userId\":\"6f...    1876210.0   \n",
       "1   {\"jobKind\":\"2\",\"jobId\":\"57437937\",\"userId\":\"d9...    7891767.0   \n",
       "2   {\"jobKind\":\"2\",\"jobId\":\"51997333\",\"userId\":\"d9...    7891767.0   \n",
       "3   {\"jobKind\":\"2\",\"jobId\":\"50965433\",\"userId\":\"14...    8112968.0   \n",
       "4   {\"jobKind\":\"2\",\"jobId\":\"55703639\",\"userId\":\"7d...    9491766.0   \n",
       "..                                                ...          ...   \n",
       "35  {\"imId\":\"ddff081e3f640fb94383db9bf147ecbd\",\"im...    8062150.0   \n",
       "36  {\"imId\":\"1c69fb72e466e3314ebbef01db417cf0\",\"im...   13531199.0   \n",
       "37  {\"imId\":\"ab96327731ebf716f279285841cea99b\",\"im...    9092472.0   \n",
       "38  {\"imId\":\"7c51dc9ff303b3c9fa40e259a967f7de\",\"im...    8706847.0   \n",
       "39  {\"imId\":\"791f1b5440a26d36cd74bb959a88946e\",\"im...    8062150.0   \n",
       "\n",
       "     comp.compName                    comp.compLogo comp.compScale  \\\n",
       "0    广州迪柯尼服饰股份有限公司  5bfe9ef274719d2aa34bac8b03a.png       500-999人   \n",
       "1   上海贝锐信息科技股份有限公司  64a5494ed5b3d376c070330502u.png       100-499人   \n",
       "2   上海贝锐信息科技股份有限公司  64a5494ed5b3d376c070330502u.png       100-499人   \n",
       "3             仙婷集团  6274ee6d04a5ff469b10880402u.png         50-99人   \n",
       "4       文远知行WeRide  60a497de907306298575785f03u.png       100-499人   \n",
       "..             ...                              ...            ...   \n",
       "35           博纳德集团  60d96977208b48306211556005u.png       500-999人   \n",
       "36            火猩未来  647e91b1274ac74c74e562d503u.png         50-99人   \n",
       "37    梅州客商银行股份有限公司  5bfe92a274719d9f609a755f03a.png       100-499人   \n",
       "38           SHEIN  5c64c511261c45f22d50d39303u.png    5000-10000人   \n",
       "39           博纳德集团  60d96977208b48306211556005u.png       500-999人   \n",
       "\n",
       "   comp.compIndustry                                 comp.link  \\\n",
       "0           服装/纺织/皮革   https://www.liepin.com/company/1876210/   \n",
       "1              计算机软件   https://www.liepin.com/company/7891767/   \n",
       "2              计算机软件   https://www.liepin.com/company/7891767/   \n",
       "3             贸易/进出口   https://www.liepin.com/company/8112968/   \n",
       "4               人工智能   https://www.liepin.com/company/9491766/   \n",
       "..               ...                                       ...   \n",
       "35             计算机软件   https://www.liepin.com/company/8062150/   \n",
       "36              电子商务  https://www.liepin.com/company/13531199/   \n",
       "37                银行   https://www.liepin.com/company/9092472/   \n",
       "38               互联网   https://www.liepin.com/company/8706847/   \n",
       "39             计算机软件   https://www.liepin.com/company/8062150/   \n",
       "\n",
       "                                           job.labels  \\\n",
       "0                      [商品企划, 数据分析, 产品规划, 波段管理, 成本分析]   \n",
       "1   [商业产品, 客户端产品, 增长产品, SaaS系统, 计算机软件, 产品规划, 团队管理,...   \n",
       "2   [SaaS产品, 商业产品, 增长产品, SaaS系统, CRM系统, 企业服务, 科研/技...   \n",
       "3   [英语, 市场推广, 市场拓展, 渠道策划, 市场策划, 市场调研分析, 乙方公司背景, t...   \n",
       "4   [工具产品, 安全产品, 客户端产品, 交通/运输/物流, 汽车行业, 自动驾驶, 产品优化...   \n",
       "..                                                ...   \n",
       "35  [SaaS产品, to B, 人事系统, HRM系统, HR模块, 人才发展, 培训, 招聘...   \n",
       "36  [小家电, 厨卫电器, 保健电器, 取暖电器, 制冷电器, 个护电器, 饮水电器, 生命周期...   \n",
       "37            [金融产品, 金融行业, 电子产品及配件, 产品优化, 用户研究, 产品规划]   \n",
       "38             [ppt, 架构设计, axure, visio, xmind, 数据分析]   \n",
       "39        [后台产品, 数据产品, IT互联网, to B, 产品设计, 产品规划, 用户研究]   \n",
       "\n",
       "                      job.title  ...  \\\n",
       "0                        商品企划经理  ...   \n",
       "1                          产品经理  ...   \n",
       "2                      产品经理（B端）  ...   \n",
       "3   产品经理（化妆品原料）/Product Manager  ...   \n",
       "4                  自动驾驶产品经理（PM）  ...   \n",
       "..                          ...  ...   \n",
       "35                   产品经理（人事系统）  ...   \n",
       "36                     资深硬件产品经理  ...   \n",
       "37                    网络金融部产品经理  ...   \n",
       "38         高级WMS产品经理 (MJ003186)  ...   \n",
       "39                      HRM产品经理  ...   \n",
       "\n",
       "                                       job.link  \\\n",
       "0   https://www.liepin.com/job/1922426839.shtml   \n",
       "1   https://www.liepin.com/job/1957437937.shtml   \n",
       "2   https://www.liepin.com/job/1951997333.shtml   \n",
       "3   https://www.liepin.com/job/1950965433.shtml   \n",
       "4   https://www.liepin.com/job/1955703639.shtml   \n",
       "..                                          ...   \n",
       "35  https://www.liepin.com/job/1961993579.shtml   \n",
       "36  https://www.liepin.com/job/1958992735.shtml   \n",
       "37  https://www.liepin.com/job/1956981809.shtml   \n",
       "38  https://www.liepin.com/job/1942074303.shtml   \n",
       "39  https://www.liepin.com/job/1962102851.shtml   \n",
       "\n",
       "                                       job.dataPromId  \\\n",
       "0   d_sfrom=search_prime&d_ckId=null&d_curPage=0&d...   \n",
       "1   d_sfrom=search_prime&d_ckId=null&d_curPage=0&d...   \n",
       "2   d_sfrom=search_prime&d_ckId=null&d_curPage=0&d...   \n",
       "3   d_sfrom=search_prime&d_ckId=null&d_curPage=0&d...   \n",
       "4   d_sfrom=search_prime&d_ckId=null&d_curPage=0&d...   \n",
       "..                                                ...   \n",
       "35  d_sfrom=search_prime&d_ckId=null&d_curPage=9&d...   \n",
       "36  d_sfrom=search_prime&d_ckId=null&d_curPage=9&d...   \n",
       "37  d_sfrom=search_prime&d_ckId=null&d_curPage=9&d...   \n",
       "38  d_sfrom=search_prime&d_ckId=null&d_curPage=9&d...   \n",
       "39  d_sfrom=search_prime&d_ckId=null&d_curPage=9&d...   \n",
       "\n",
       "                      recruiter.imId recruiter.imUserType recruiter.chatted  \\\n",
       "0   492a74489f2f8a893eaad1f295204b5b                    2             False   \n",
       "1   e9d800aebed3ce4e67766a03c68ce883                    2             False   \n",
       "2   e9d800aebed3ce4e67766a03c68ce883                    2             False   \n",
       "3   0ce6f53a162e27cc9427b88c78d2ff1f                    2             False   \n",
       "4   e2b135092ee70a2ae950a599d250d4ad                    2             False   \n",
       "..                               ...                  ...               ...   \n",
       "35  ddff081e3f640fb94383db9bf147ecbd                    2             False   \n",
       "36  1c69fb72e466e3314ebbef01db417cf0                    2             False   \n",
       "37  ab96327731ebf716f279285841cea99b                    2             False   \n",
       "38  7c51dc9ff303b3c9fa40e259a967f7de                    2             False   \n",
       "39  791f1b5440a26d36cd74bb959a88946e                    2             False   \n",
       "\n",
       "   recruiter.recruiterName  recruiter.recruiterTitle  \\\n",
       "0                      刘女士                       招聘者   \n",
       "1                      张先生                        hr   \n",
       "2                      张先生                        hr   \n",
       "3                      吴女士                HR Officer   \n",
       "4                      侯先生                      HRBP   \n",
       "..                     ...                       ...   \n",
       "35                     唐女士                    高级招聘经理   \n",
       "36                     李女士                      招聘专员   \n",
       "37                     李女士                  人事主管hrbp   \n",
       "38                     贺女士                  助理顾问(AC)   \n",
       "39                     植先生                    高级招聘顾问   \n",
       "\n",
       "               recruiter.recruiterId         recruiter.recruiterPhoto  \\\n",
       "0   6f37571c13bed9fc606640b0edee6eee  5f8f9863f6d1ab58476f246a08u.jpg   \n",
       "1   d938dfd61b82bb63e0d7e82a5823cab2  5f8f986c79c7cc70efbf36c808u.jpg   \n",
       "2   d938dfd61b82bb63e0d7e82a5823cab2  5f8f986c79c7cc70efbf36c808u.jpg   \n",
       "3   14799e1bef289c70aa9b550257de7ea8  5f8f98648dbe6273dcf8515508u.jpg   \n",
       "4   7da08eb2dc102f58400ecda04a611db0  5f8f986bdfb13a7dee342f2108u.jpg   \n",
       "..                               ...                              ...   \n",
       "35  af74d747eb8fff70ad63c04ba6f2e71b  5f8f986779c7cc70efbf36c008u.jpg   \n",
       "36  083bf20a22f9eb25f205ad6f39096483  5f8f9866dfb13a7dee342f1808u.jpg   \n",
       "37  3b9b7106ae3c037eeecc0881016258b0  5f8f9866dfb13a7dee342f1808u.jpg   \n",
       "38  9294a5a1e3837c5ebb372434d8d59956  5f8f9863f6d1ab58476f246a08u.jpg   \n",
       "39  a7b48e55484d5f5cdcc3f8271f977e46  5f8f986aea60860b75384fab08u.jpg   \n",
       "\n",
       "    comp.compStage  \n",
       "0              NaN  \n",
       "1               B轮  \n",
       "2               B轮  \n",
       "3              NaN  \n",
       "4               D轮  \n",
       "..             ...  \n",
       "35             NaN  \n",
       "36             NaN  \n",
       "37             NaN  \n",
       "38             NaN  \n",
       "39             NaN  \n",
       "\n",
       "[400 rows x 31 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import crawl_liepin\n",
    "城市 = input(\"请输入城市：\")\n",
    "关键词 = input(\"请输入职位：\")\n",
    "af= crawl_liepin.crawl(城市=城市,关键词=关键词)\n",
    "af"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "f03f2340",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['dataInfo', 'dataParams', 'comp.compId', 'comp.compName',\n",
       "       'comp.compLogo', 'comp.compScale', 'comp.compIndustry', 'comp.link',\n",
       "       'job.labels', 'job.title', 'job.requireEduLevel', 'job.jobKind',\n",
       "       'job.jobId', 'job.dq', 'job.refreshTime', 'job.requireWorkYears',\n",
       "       'job.advViewFlag', 'job.pcOuterLink', 'job.h5OuterLink', 'job.topJob',\n",
       "       'job.salary', 'job.link', 'job.dataPromId', 'recruiter.imId',\n",
       "       'recruiter.imUserType', 'recruiter.chatted', 'recruiter.recruiterName',\n",
       "       'recruiter.recruiterTitle', 'recruiter.recruiterId',\n",
       "       'recruiter.recruiterPhoto', 'comp.compStage'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "af.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "de174a13",
   "metadata": {},
   "source": [
    "# 可分析的列\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "2f20cb90",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>job.labels</th>\n",
       "      <th>job.refreshTime</th>\n",
       "      <th>job.title</th>\n",
       "      <th>job.salary</th>\n",
       "      <th>job.dq</th>\n",
       "      <th>job.topJob</th>\n",
       "      <th>job.requireWorkYears</th>\n",
       "      <th>job.requireEduLevel</th>\n",
       "      <th>comp.compStage</th>\n",
       "      <th>comp.compName</th>\n",
       "      <th>comp.compIndustry</th>\n",
       "      <th>comp.compScale</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[商品企划, 数据分析, 产品规划, 波段管理, 成本分析]</td>\n",
       "      <td>20231107105852</td>\n",
       "      <td>商品企划经理</td>\n",
       "      <td>18-25k</td>\n",
       "      <td>广州</td>\n",
       "      <td>True</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>大专</td>\n",
       "      <td>NaN</td>\n",
       "      <td>广州迪柯尼服饰股份有限公司</td>\n",
       "      <td>服装/纺织/皮革</td>\n",
       "      <td>500-999人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>[商业产品, 客户端产品, 增长产品, SaaS系统, 计算机软件, 产品规划, 团队管理,...</td>\n",
       "      <td>20230904165749</td>\n",
       "      <td>产品经理</td>\n",
       "      <td>薪资面议</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>True</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>B轮</td>\n",
       "      <td>上海贝锐信息科技股份有限公司</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>100-499人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>[SaaS产品, 商业产品, 增长产品, SaaS系统, CRM系统, 企业服务, 科研/技...</td>\n",
       "      <td>20230904165745</td>\n",
       "      <td>产品经理（B端）</td>\n",
       "      <td>薪资面议</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>True</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>本科</td>\n",
       "      <td>B轮</td>\n",
       "      <td>上海贝锐信息科技股份有限公司</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>100-499人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>[英语, 市场推广, 市场拓展, 渠道策划, 市场策划, 市场调研分析, 乙方公司背景, t...</td>\n",
       "      <td>20231102113603</td>\n",
       "      <td>产品经理（化妆品原料）/Product Manager</td>\n",
       "      <td>薪资面议</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>硕士</td>\n",
       "      <td>NaN</td>\n",
       "      <td>仙婷集团</td>\n",
       "      <td>贸易/进出口</td>\n",
       "      <td>50-99人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>[工具产品, 安全产品, 客户端产品, 交通/运输/物流, 汽车行业, 自动驾驶, 产品优化...</td>\n",
       "      <td>20231025170441</td>\n",
       "      <td>自动驾驶产品经理（PM）</td>\n",
       "      <td>25-35k</td>\n",
       "      <td>广州-海珠区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>D轮</td>\n",
       "      <td>文远知行WeRide</td>\n",
       "      <td>人工智能</td>\n",
       "      <td>100-499人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>[SaaS产品, to B, 人事系统, HRM系统, HR模块, 人才发展, 培训, 招聘...</td>\n",
       "      <td>20231108090734</td>\n",
       "      <td>产品经理（人事系统）</td>\n",
       "      <td>15-25k</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>大专</td>\n",
       "      <td>NaN</td>\n",
       "      <td>博纳德集团</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>500-999人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>[小家电, 厨卫电器, 保健电器, 取暖电器, 制冷电器, 个护电器, 饮水电器, 生命周期...</td>\n",
       "      <td>20231016142930</td>\n",
       "      <td>资深硬件产品经理</td>\n",
       "      <td>25-30k</td>\n",
       "      <td>广州-番禺区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>大专</td>\n",
       "      <td>NaN</td>\n",
       "      <td>火猩未来</td>\n",
       "      <td>电子商务</td>\n",
       "      <td>50-99人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>[金融产品, 金融行业, 电子产品及配件, 产品优化, 用户研究, 产品规划]</td>\n",
       "      <td>20230822142521</td>\n",
       "      <td>网络金融部产品经理</td>\n",
       "      <td>薪资面议</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>NaN</td>\n",
       "      <td>梅州客商银行股份有限公司</td>\n",
       "      <td>银行</td>\n",
       "      <td>100-499人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>[ppt, 架构设计, axure, visio, xmind, 数据分析]</td>\n",
       "      <td>20230704162107</td>\n",
       "      <td>高级WMS产品经理 (MJ003186)</td>\n",
       "      <td>20-40k·14薪</td>\n",
       "      <td>广州-番禺区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>大专</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SHEIN</td>\n",
       "      <td>互联网</td>\n",
       "      <td>5000-10000人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>[后台产品, 数据产品, IT互联网, to B, 产品设计, 产品规划, 用户研究]</td>\n",
       "      <td>20231108135824</td>\n",
       "      <td>HRM产品经理</td>\n",
       "      <td>15-25k</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>大专</td>\n",
       "      <td>NaN</td>\n",
       "      <td>博纳德集团</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>500-999人</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>400 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           job.labels job.refreshTime  \\\n",
       "0                      [商品企划, 数据分析, 产品规划, 波段管理, 成本分析]  20231107105852   \n",
       "1   [商业产品, 客户端产品, 增长产品, SaaS系统, 计算机软件, 产品规划, 团队管理,...  20230904165749   \n",
       "2   [SaaS产品, 商业产品, 增长产品, SaaS系统, CRM系统, 企业服务, 科研/技...  20230904165745   \n",
       "3   [英语, 市场推广, 市场拓展, 渠道策划, 市场策划, 市场调研分析, 乙方公司背景, t...  20231102113603   \n",
       "4   [工具产品, 安全产品, 客户端产品, 交通/运输/物流, 汽车行业, 自动驾驶, 产品优化...  20231025170441   \n",
       "..                                                ...             ...   \n",
       "35  [SaaS产品, to B, 人事系统, HRM系统, HR模块, 人才发展, 培训, 招聘...  20231108090734   \n",
       "36  [小家电, 厨卫电器, 保健电器, 取暖电器, 制冷电器, 个护电器, 饮水电器, 生命周期...  20231016142930   \n",
       "37            [金融产品, 金融行业, 电子产品及配件, 产品优化, 用户研究, 产品规划]  20230822142521   \n",
       "38             [ppt, 架构设计, axure, visio, xmind, 数据分析]  20230704162107   \n",
       "39        [后台产品, 数据产品, IT互联网, to B, 产品设计, 产品规划, 用户研究]  20231108135824   \n",
       "\n",
       "                      job.title  job.salary  job.dq  job.topJob  \\\n",
       "0                        商品企划经理      18-25k      广州        True   \n",
       "1                          产品经理        薪资面议  广州-天河区        True   \n",
       "2                      产品经理（B端）        薪资面议  广州-天河区        True   \n",
       "3   产品经理（化妆品原料）/Product Manager        薪资面议  广州-天河区       False   \n",
       "4                  自动驾驶产品经理（PM）      25-35k  广州-海珠区       False   \n",
       "..                          ...         ...     ...         ...   \n",
       "35                   产品经理（人事系统）      15-25k  广州-天河区       False   \n",
       "36                     资深硬件产品经理      25-30k  广州-番禺区       False   \n",
       "37                    网络金融部产品经理        薪资面议  广州-天河区       False   \n",
       "38         高级WMS产品经理 (MJ003186)  20-40k·14薪  广州-番禺区       False   \n",
       "39                      HRM产品经理      15-25k  广州-天河区       False   \n",
       "\n",
       "   job.requireWorkYears job.requireEduLevel comp.compStage   comp.compName  \\\n",
       "0                 5-10年                  大专            NaN   广州迪柯尼服饰股份有限公司   \n",
       "1                 5-10年                统招本科             B轮  上海贝锐信息科技股份有限公司   \n",
       "2                 5-10年                  本科             B轮  上海贝锐信息科技股份有限公司   \n",
       "3                  3-5年                  硕士            NaN            仙婷集团   \n",
       "4                  3-5年                统招本科             D轮      文远知行WeRide   \n",
       "..                  ...                 ...            ...             ...   \n",
       "35                 3-5年                  大专            NaN           博纳德集团   \n",
       "36                 3-5年                  大专            NaN            火猩未来   \n",
       "37                 3-5年                统招本科            NaN    梅州客商银行股份有限公司   \n",
       "38                 3-5年                  大专            NaN           SHEIN   \n",
       "39                 3-5年                  大专            NaN           博纳德集团   \n",
       "\n",
       "   comp.compIndustry comp.compScale  \n",
       "0           服装/纺织/皮革       500-999人  \n",
       "1              计算机软件       100-499人  \n",
       "2              计算机软件       100-499人  \n",
       "3             贸易/进出口         50-99人  \n",
       "4               人工智能       100-499人  \n",
       "..               ...            ...  \n",
       "35             计算机软件       500-999人  \n",
       "36              电子商务         50-99人  \n",
       "37                银行       100-499人  \n",
       "38               互联网    5000-10000人  \n",
       "39             计算机软件       500-999人  \n",
       "\n",
       "[400 rows x 12 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_PM_gz =  af[['job.labels','job.refreshTime','job.title','job.salary','job.dq','job.topJob','job.requireWorkYears','job.requireEduLevel','comp.compStage','comp.compName','comp.compIndustry','comp.compScale']]\n",
    "df_PM_gz"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "1fe57c80",
   "metadata": {},
   "outputs": [],
   "source": [
    "from pyecharts import options as opts\n",
    "from pyecharts.charts import Bar, Grid, Line,Map,Page,WordCloud\n",
    "from pyecharts.faker import Faker"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b3c67b16",
   "metadata": {},
   "source": [
    "# 地图"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "28918200",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "广州        110\n",
       "广州-天河区     87\n",
       "广州-番禺区     48\n",
       "广州-黄埔区     42\n",
       "广州-海珠区     38\n",
       "广州-越秀区     30\n",
       "广州-白云区     24\n",
       "广州-荔湾区     15\n",
       "广州-南沙区      4\n",
       "广州-花都区      2\n",
       "Name: job.dq, dtype: int64"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_PM_gz['job.dq'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "10c0b3e9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['广州-天河区',\n",
       " '广州-番禺区',\n",
       " '广州-黄埔区',\n",
       " '广州-海珠区',\n",
       " '广州-越秀区',\n",
       " '广州-白云区',\n",
       " '广州-荔湾区',\n",
       " '广州-南沙区',\n",
       " '广州-花都区']"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "[i for i in df_PM_gz['job.dq'].value_counts().index.tolist() if '-' in i]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "deb28e4b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['天河区', '番禺区', '黄埔区', '海珠区', '越秀区', '白云区', '荔湾区', '南沙区', '花都区']"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "地区 = [ df_PM_gz['job.dq'].value_counts().index.tolist()[i].split('-')[1]\\\n",
    "     for i, v in enumerate(df_PM_gz['job.dq'].value_counts().index.tolist()) if '-' in v]\n",
    "地区"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "e6b873f2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[87, 48, 42, 38, 30, 24, 15, 4, 2]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "岗位个数 =[ df_PM_gz['job.dq'].value_counts().values.tolist()[i]   for i,v in enumerate(df_PM_gz['job.dq'].value_counts().index.tolist()) if '-' in v]\n",
    "岗位个数"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "f64354f9",
   "metadata": {},
   "outputs": [],
   "source": [
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "cc93eaec",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>job.labels</th>\n",
       "      <th>job.refreshTime</th>\n",
       "      <th>job.title</th>\n",
       "      <th>job.salary</th>\n",
       "      <th>job.dq</th>\n",
       "      <th>job.topJob</th>\n",
       "      <th>job.requireWorkYears</th>\n",
       "      <th>job.requireEduLevel</th>\n",
       "      <th>comp.compStage</th>\n",
       "      <th>comp.compName</th>\n",
       "      <th>comp.compIndustry</th>\n",
       "      <th>comp.compScale</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[商品企划, 数据分析, 产品规划, 波段管理, 成本分析]</td>\n",
       "      <td>20231107105852</td>\n",
       "      <td>商品企划经理</td>\n",
       "      <td>18-25k</td>\n",
       "      <td>广州</td>\n",
       "      <td>True</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>大专</td>\n",
       "      <td>NaN</td>\n",
       "      <td>广州迪柯尼服饰股份有限公司</td>\n",
       "      <td>服装/纺织/皮革</td>\n",
       "      <td>500-999人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>[商业产品, 客户端产品, 增长产品, SaaS系统, 计算机软件, 产品规划, 团队管理,...</td>\n",
       "      <td>20230904165749</td>\n",
       "      <td>产品经理</td>\n",
       "      <td>薪资面议</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>True</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>B轮</td>\n",
       "      <td>上海贝锐信息科技股份有限公司</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>100-499人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>[SaaS产品, 商业产品, 增长产品, SaaS系统, CRM系统, 企业服务, 科研/技...</td>\n",
       "      <td>20230904165745</td>\n",
       "      <td>产品经理（B端）</td>\n",
       "      <td>薪资面议</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>True</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>本科</td>\n",
       "      <td>B轮</td>\n",
       "      <td>上海贝锐信息科技股份有限公司</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>100-499人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>[英语, 市场推广, 市场拓展, 渠道策划, 市场策划, 市场调研分析, 乙方公司背景, t...</td>\n",
       "      <td>20231102113603</td>\n",
       "      <td>产品经理（化妆品原料）/Product Manager</td>\n",
       "      <td>薪资面议</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>硕士</td>\n",
       "      <td>NaN</td>\n",
       "      <td>仙婷集团</td>\n",
       "      <td>贸易/进出口</td>\n",
       "      <td>50-99人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>[工具产品, 安全产品, 客户端产品, 交通/运输/物流, 汽车行业, 自动驾驶, 产品优化...</td>\n",
       "      <td>20231025170441</td>\n",
       "      <td>自动驾驶产品经理（PM）</td>\n",
       "      <td>25-35k</td>\n",
       "      <td>广州-海珠区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>D轮</td>\n",
       "      <td>文远知行WeRide</td>\n",
       "      <td>人工智能</td>\n",
       "      <td>100-499人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>[SaaS产品, to B, 人事系统, HRM系统, HR模块, 人才发展, 培训, 招聘...</td>\n",
       "      <td>20231108090734</td>\n",
       "      <td>产品经理（人事系统）</td>\n",
       "      <td>15-25k</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>大专</td>\n",
       "      <td>NaN</td>\n",
       "      <td>博纳德集团</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>500-999人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>[小家电, 厨卫电器, 保健电器, 取暖电器, 制冷电器, 个护电器, 饮水电器, 生命周期...</td>\n",
       "      <td>20231016142930</td>\n",
       "      <td>资深硬件产品经理</td>\n",
       "      <td>25-30k</td>\n",
       "      <td>广州-番禺区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>大专</td>\n",
       "      <td>NaN</td>\n",
       "      <td>火猩未来</td>\n",
       "      <td>电子商务</td>\n",
       "      <td>50-99人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>[金融产品, 金融行业, 电子产品及配件, 产品优化, 用户研究, 产品规划]</td>\n",
       "      <td>20230822142521</td>\n",
       "      <td>网络金融部产品经理</td>\n",
       "      <td>薪资面议</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>NaN</td>\n",
       "      <td>梅州客商银行股份有限公司</td>\n",
       "      <td>银行</td>\n",
       "      <td>100-499人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>[ppt, 架构设计, axure, visio, xmind, 数据分析]</td>\n",
       "      <td>20230704162107</td>\n",
       "      <td>高级WMS产品经理 (MJ003186)</td>\n",
       "      <td>20-40k·14薪</td>\n",
       "      <td>广州-番禺区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>大专</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SHEIN</td>\n",
       "      <td>互联网</td>\n",
       "      <td>5000-10000人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>[后台产品, 数据产品, IT互联网, to B, 产品设计, 产品规划, 用户研究]</td>\n",
       "      <td>20231108135824</td>\n",
       "      <td>HRM产品经理</td>\n",
       "      <td>15-25k</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>大专</td>\n",
       "      <td>NaN</td>\n",
       "      <td>博纳德集团</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>500-999人</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>372 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           job.labels job.refreshTime  \\\n",
       "0                      [商品企划, 数据分析, 产品规划, 波段管理, 成本分析]  20231107105852   \n",
       "1   [商业产品, 客户端产品, 增长产品, SaaS系统, 计算机软件, 产品规划, 团队管理,...  20230904165749   \n",
       "2   [SaaS产品, 商业产品, 增长产品, SaaS系统, CRM系统, 企业服务, 科研/技...  20230904165745   \n",
       "3   [英语, 市场推广, 市场拓展, 渠道策划, 市场策划, 市场调研分析, 乙方公司背景, t...  20231102113603   \n",
       "4   [工具产品, 安全产品, 客户端产品, 交通/运输/物流, 汽车行业, 自动驾驶, 产品优化...  20231025170441   \n",
       "..                                                ...             ...   \n",
       "35  [SaaS产品, to B, 人事系统, HRM系统, HR模块, 人才发展, 培训, 招聘...  20231108090734   \n",
       "36  [小家电, 厨卫电器, 保健电器, 取暖电器, 制冷电器, 个护电器, 饮水电器, 生命周期...  20231016142930   \n",
       "37            [金融产品, 金融行业, 电子产品及配件, 产品优化, 用户研究, 产品规划]  20230822142521   \n",
       "38             [ppt, 架构设计, axure, visio, xmind, 数据分析]  20230704162107   \n",
       "39        [后台产品, 数据产品, IT互联网, to B, 产品设计, 产品规划, 用户研究]  20231108135824   \n",
       "\n",
       "                      job.title  job.salary  job.dq  job.topJob  \\\n",
       "0                        商品企划经理      18-25k      广州        True   \n",
       "1                          产品经理        薪资面议  广州-天河区        True   \n",
       "2                      产品经理（B端）        薪资面议  广州-天河区        True   \n",
       "3   产品经理（化妆品原料）/Product Manager        薪资面议  广州-天河区       False   \n",
       "4                  自动驾驶产品经理（PM）      25-35k  广州-海珠区       False   \n",
       "..                          ...         ...     ...         ...   \n",
       "35                   产品经理（人事系统）      15-25k  广州-天河区       False   \n",
       "36                     资深硬件产品经理      25-30k  广州-番禺区       False   \n",
       "37                    网络金融部产品经理        薪资面议  广州-天河区       False   \n",
       "38         高级WMS产品经理 (MJ003186)  20-40k·14薪  广州-番禺区       False   \n",
       "39                      HRM产品经理      15-25k  广州-天河区       False   \n",
       "\n",
       "   job.requireWorkYears job.requireEduLevel comp.compStage   comp.compName  \\\n",
       "0                 5-10年                  大专            NaN   广州迪柯尼服饰股份有限公司   \n",
       "1                 5-10年                统招本科             B轮  上海贝锐信息科技股份有限公司   \n",
       "2                 5-10年                  本科             B轮  上海贝锐信息科技股份有限公司   \n",
       "3                  3-5年                  硕士            NaN            仙婷集团   \n",
       "4                  3-5年                统招本科             D轮      文远知行WeRide   \n",
       "..                  ...                 ...            ...             ...   \n",
       "35                 3-5年                  大专            NaN           博纳德集团   \n",
       "36                 3-5年                  大专            NaN            火猩未来   \n",
       "37                 3-5年                统招本科            NaN    梅州客商银行股份有限公司   \n",
       "38                 3-5年                  大专            NaN           SHEIN   \n",
       "39                 3-5年                  大专            NaN           博纳德集团   \n",
       "\n",
       "   comp.compIndustry comp.compScale  \n",
       "0           服装/纺织/皮革       500-999人  \n",
       "1              计算机软件       100-499人  \n",
       "2              计算机软件       100-499人  \n",
       "3             贸易/进出口         50-99人  \n",
       "4               人工智能       100-499人  \n",
       "..               ...            ...  \n",
       "35             计算机软件       500-999人  \n",
       "36              电子商务         50-99人  \n",
       "37                银行       100-499人  \n",
       "38               互联网    5000-10000人  \n",
       "39             计算机软件       500-999人  \n",
       "\n",
       "[372 rows x 12 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "we = df_PM_gz[df_PM_gz['job.requireWorkYears'].fillna('').str.strip() != '经验不限']\n",
    "we"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5622bef3",
   "metadata": {},
   "source": [
    "# 平均薪资"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "53449ead",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>job.labels</th>\n",
       "      <th>job.refreshTime</th>\n",
       "      <th>job.title</th>\n",
       "      <th>job.salary</th>\n",
       "      <th>job.dq</th>\n",
       "      <th>job.topJob</th>\n",
       "      <th>job.requireWorkYears</th>\n",
       "      <th>job.requireEduLevel</th>\n",
       "      <th>comp.compStage</th>\n",
       "      <th>comp.compName</th>\n",
       "      <th>comp.compIndustry</th>\n",
       "      <th>comp.compScale</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[商品企划, 数据分析, 产品规划, 波段管理, 成本分析]</td>\n",
       "      <td>20231107105852</td>\n",
       "      <td>商品企划经理</td>\n",
       "      <td>18-25k</td>\n",
       "      <td>广州</td>\n",
       "      <td>True</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>大专</td>\n",
       "      <td>NaN</td>\n",
       "      <td>广州迪柯尼服饰股份有限公司</td>\n",
       "      <td>服装/纺织/皮革</td>\n",
       "      <td>500-999人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>[工具产品, 安全产品, 客户端产品, 交通/运输/物流, 汽车行业, 自动驾驶, 产品优化...</td>\n",
       "      <td>20231025170441</td>\n",
       "      <td>自动驾驶产品经理（PM）</td>\n",
       "      <td>25-35k</td>\n",
       "      <td>广州-海珠区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>D轮</td>\n",
       "      <td>文远知行WeRide</td>\n",
       "      <td>人工智能</td>\n",
       "      <td>100-499人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>[神外, 医生]</td>\n",
       "      <td>20230428143658</td>\n",
       "      <td>神外产品销售经理 Product Sales Manager</td>\n",
       "      <td>12-15k·15薪</td>\n",
       "      <td>广州-越秀区</td>\n",
       "      <td>False</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>已上市</td>\n",
       "      <td>复星医药集团</td>\n",
       "      <td>制药</td>\n",
       "      <td>10000人以上</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>[]</td>\n",
       "      <td>20230626175056</td>\n",
       "      <td>Automation Product Manager</td>\n",
       "      <td>20-40k·13薪</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>False</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>本科</td>\n",
       "      <td>NaN</td>\n",
       "      <td>丹纳赫</td>\n",
       "      <td>医疗器械</td>\n",
       "      <td>5000-10000人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>[全国市场管理]</td>\n",
       "      <td>20231108141556</td>\n",
       "      <td>全国市务经理</td>\n",
       "      <td>20-30k</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>False</td>\n",
       "      <td>10年以上</td>\n",
       "      <td>本科</td>\n",
       "      <td>NaN</td>\n",
       "      <td>捷荣食品</td>\n",
       "      <td>食品/饮料/酒水</td>\n",
       "      <td>100-499人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>[数据产品, 策略产品, 数据分析, 产品设计, 需求分析, 用户研究, 产品规划]</td>\n",
       "      <td>20230907142342</td>\n",
       "      <td>高级产品经理（数据方向）</td>\n",
       "      <td>20-40k</td>\n",
       "      <td>广州-海珠区</td>\n",
       "      <td>False</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>本科</td>\n",
       "      <td>NaN</td>\n",
       "      <td>某广州IT服务公司</td>\n",
       "      <td>IT服务</td>\n",
       "      <td>100-499人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>[SaaS产品, to B, 人事系统, HRM系统, HR模块, 人才发展, 培训, 招聘...</td>\n",
       "      <td>20231108090734</td>\n",
       "      <td>产品经理（人事系统）</td>\n",
       "      <td>15-25k</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>大专</td>\n",
       "      <td>NaN</td>\n",
       "      <td>博纳德集团</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>500-999人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>[小家电, 厨卫电器, 保健电器, 取暖电器, 制冷电器, 个护电器, 饮水电器, 生命周期...</td>\n",
       "      <td>20231016142930</td>\n",
       "      <td>资深硬件产品经理</td>\n",
       "      <td>25-30k</td>\n",
       "      <td>广州-番禺区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>大专</td>\n",
       "      <td>NaN</td>\n",
       "      <td>火猩未来</td>\n",
       "      <td>电子商务</td>\n",
       "      <td>50-99人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>[ppt, 架构设计, axure, visio, xmind, 数据分析]</td>\n",
       "      <td>20230704162107</td>\n",
       "      <td>高级WMS产品经理 (MJ003186)</td>\n",
       "      <td>20-40k·14薪</td>\n",
       "      <td>广州-番禺区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>大专</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SHEIN</td>\n",
       "      <td>互联网</td>\n",
       "      <td>5000-10000人</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>[后台产品, 数据产品, IT互联网, to B, 产品设计, 产品规划, 用户研究]</td>\n",
       "      <td>20231108135824</td>\n",
       "      <td>HRM产品经理</td>\n",
       "      <td>15-25k</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>大专</td>\n",
       "      <td>NaN</td>\n",
       "      <td>博纳德集团</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>500-999人</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>359 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           job.labels job.refreshTime  \\\n",
       "0                      [商品企划, 数据分析, 产品规划, 波段管理, 成本分析]  20231107105852   \n",
       "4   [工具产品, 安全产品, 客户端产品, 交通/运输/物流, 汽车行业, 自动驾驶, 产品优化...  20231025170441   \n",
       "6                                            [神外, 医生]  20230428143658   \n",
       "8                                                  []  20230626175056   \n",
       "9                                            [全国市场管理]  20231108141556   \n",
       "..                                                ...             ...   \n",
       "34         [数据产品, 策略产品, 数据分析, 产品设计, 需求分析, 用户研究, 产品规划]  20230907142342   \n",
       "35  [SaaS产品, to B, 人事系统, HRM系统, HR模块, 人才发展, 培训, 招聘...  20231108090734   \n",
       "36  [小家电, 厨卫电器, 保健电器, 取暖电器, 制冷电器, 个护电器, 饮水电器, 生命周期...  20231016142930   \n",
       "38             [ppt, 架构设计, axure, visio, xmind, 数据分析]  20230704162107   \n",
       "39        [后台产品, 数据产品, IT互联网, to B, 产品设计, 产品规划, 用户研究]  20231108135824   \n",
       "\n",
       "                         job.title  job.salary  job.dq  job.topJob  \\\n",
       "0                           商品企划经理      18-25k      广州        True   \n",
       "4                     自动驾驶产品经理（PM）      25-35k  广州-海珠区       False   \n",
       "6   神外产品销售经理 Product Sales Manager  12-15k·15薪  广州-越秀区       False   \n",
       "8       Automation Product Manager  20-40k·13薪  广州-天河区       False   \n",
       "9                           全国市务经理      20-30k  广州-天河区       False   \n",
       "..                             ...         ...     ...         ...   \n",
       "34                    高级产品经理（数据方向）      20-40k  广州-海珠区       False   \n",
       "35                      产品经理（人事系统）      15-25k  广州-天河区       False   \n",
       "36                        资深硬件产品经理      25-30k  广州-番禺区       False   \n",
       "38            高级WMS产品经理 (MJ003186)  20-40k·14薪  广州-番禺区       False   \n",
       "39                         HRM产品经理      15-25k  广州-天河区       False   \n",
       "\n",
       "   job.requireWorkYears job.requireEduLevel comp.compStage  comp.compName  \\\n",
       "0                 5-10年                  大专            NaN  广州迪柯尼服饰股份有限公司   \n",
       "4                  3-5年                统招本科             D轮     文远知行WeRide   \n",
       "6                  1-3年                统招本科            已上市         复星医药集团   \n",
       "8                 5-10年                  本科            NaN            丹纳赫   \n",
       "9                 10年以上                  本科            NaN           捷荣食品   \n",
       "..                  ...                 ...            ...            ...   \n",
       "34                5-10年                  本科            NaN      某广州IT服务公司   \n",
       "35                 3-5年                  大专            NaN          博纳德集团   \n",
       "36                 3-5年                  大专            NaN           火猩未来   \n",
       "38                 3-5年                  大专            NaN          SHEIN   \n",
       "39                 3-5年                  大专            NaN          博纳德集团   \n",
       "\n",
       "   comp.compIndustry comp.compScale  \n",
       "0           服装/纺织/皮革       500-999人  \n",
       "4               人工智能       100-499人  \n",
       "6                 制药       10000人以上  \n",
       "8               医疗器械    5000-10000人  \n",
       "9           食品/饮料/酒水       100-499人  \n",
       "..               ...            ...  \n",
       "34              IT服务       100-499人  \n",
       "35             计算机软件       500-999人  \n",
       "36              电子商务         50-99人  \n",
       "38               互联网    5000-10000人  \n",
       "39             计算机软件       500-999人  \n",
       "\n",
       "[359 rows x 12 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "非薪资面议=we[ ~we['job.salary'].str.contains(\"薪资面议\"and \"面议|元/天\") ]\n",
    "\n",
    "非薪资面议"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "ca0f2d89",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[['18-25k'],\n",
       " ['25-35k'],\n",
       " ['12-15k', '15'],\n",
       " ['20-40k', '13'],\n",
       " ['20-30k'],\n",
       " ['35-45k'],\n",
       " ['30-40k'],\n",
       " ['15-30k', '13'],\n",
       " ['20-30k'],\n",
       " ['40-50k', '15'],\n",
       " ['18-40k', '14'],\n",
       " ['18-30k'],\n",
       " ['12-30k'],\n",
       " ['14-28k', '16'],\n",
       " ['25-30k', '14'],\n",
       " ['30-35k', '15'],\n",
       " ['16-22k'],\n",
       " ['15-30k', '20'],\n",
       " ['15-25k'],\n",
       " ['11-22k'],\n",
       " ['20-30k', '14'],\n",
       " ['20-30k', '14'],\n",
       " ['15-30k', '13'],\n",
       " ['12-18k', '13'],\n",
       " ['25-45k'],\n",
       " ['10-18k'],\n",
       " ['20-40k'],\n",
       " ['20-40k'],\n",
       " ['20-40k'],\n",
       " ['25-35k'],\n",
       " ['16-20k'],\n",
       " ['15-20k', '13'],\n",
       " ['20-40k'],\n",
       " ['15-30k'],\n",
       " ['18-25k', '14'],\n",
       " ['20-30k'],\n",
       " ['21-29k', '14'],\n",
       " ['15-20k'],\n",
       " ['15-20k'],\n",
       " ['20-30k', '13'],\n",
       " ['16-18k'],\n",
       " ['10-18k'],\n",
       " ['12-20k'],\n",
       " ['15-24k'],\n",
       " ['15-25k'],\n",
       " ['10-15k'],\n",
       " ['15-25k'],\n",
       " ['20-40k'],\n",
       " ['15-25k'],\n",
       " ['25-40k'],\n",
       " ['40-50k'],\n",
       " ['18-25k', '14'],\n",
       " ['13-18k', '13'],\n",
       " ['15-30k', '16'],\n",
       " ['12-25k', '14'],\n",
       " ['20-30k'],\n",
       " ['40-45k', '13'],\n",
       " ['25-40k'],\n",
       " ['20-40k', '14'],\n",
       " ['20-40k', '13'],\n",
       " ['25-35k', '14'],\n",
       " ['20-40k', '14'],\n",
       " ['25-45k'],\n",
       " ['15-30k'],\n",
       " ['25-45k'],\n",
       " ['12-20k', '13'],\n",
       " ['12-20k'],\n",
       " ['20-30k'],\n",
       " ['10-15k', '13'],\n",
       " ['30-40k', '16'],\n",
       " ['25-45k'],\n",
       " ['30-40k'],\n",
       " ['18-25k', '13'],\n",
       " ['15-30k'],\n",
       " ['25-45k'],\n",
       " ['20-40k'],\n",
       " ['12-20k'],\n",
       " ['20-40k'],\n",
       " ['30-50k'],\n",
       " ['15-30k'],\n",
       " ['20-30k'],\n",
       " ['15-30k'],\n",
       " ['15-30k'],\n",
       " ['15-30k'],\n",
       " ['12-20k'],\n",
       " ['12-20k'],\n",
       " ['30-40k', '18'],\n",
       " ['15-30k', '13'],\n",
       " ['20-33k', '14'],\n",
       " ['15-30k'],\n",
       " ['18-30k', '15'],\n",
       " ['8-15k'],\n",
       " ['25-35k'],\n",
       " ['15-30k'],\n",
       " ['25-35k'],\n",
       " ['25-40k'],\n",
       " ['15-20k'],\n",
       " ['15-20k'],\n",
       " ['20-25k'],\n",
       " ['12-20k'],\n",
       " ['12-15k', '13'],\n",
       " ['18-25k'],\n",
       " ['7-15k'],\n",
       " ['21-29k', '14'],\n",
       " ['20-35k'],\n",
       " ['25-40k', '13'],\n",
       " ['15-30k'],\n",
       " ['9-13k'],\n",
       " ['18-25k'],\n",
       " ['10-18k'],\n",
       " ['13-15k'],\n",
       " ['15-20k'],\n",
       " ['15-30k', '13'],\n",
       " ['20-40k'],\n",
       " ['12-20k'],\n",
       " ['20-25k'],\n",
       " ['15-20k'],\n",
       " ['15-25k'],\n",
       " ['15-30k', '13'],\n",
       " ['20-35k', '14'],\n",
       " ['25-40k', '14'],\n",
       " ['15-19k', '15'],\n",
       " ['20-40k', '14'],\n",
       " ['22-25k', '14'],\n",
       " ['20-40k', '14'],\n",
       " ['20-40k'],\n",
       " ['15-25k', '13'],\n",
       " ['15-20k'],\n",
       " ['25-40k', '13'],\n",
       " ['20-30k', '13'],\n",
       " ['20-30k'],\n",
       " ['20-35k', '15'],\n",
       " ['20-40k'],\n",
       " ['15-25k', '15'],\n",
       " ['20-30k'],\n",
       " ['20-30k'],\n",
       " ['20-25k'],\n",
       " ['15-40k', '14'],\n",
       " ['15-30k'],\n",
       " ['18-25k', '13'],\n",
       " ['18-28k', '13'],\n",
       " ['20-40k'],\n",
       " ['50-60k'],\n",
       " ['20-35k'],\n",
       " ['25-40k', '13'],\n",
       " ['25-35k'],\n",
       " ['30-50k', '14'],\n",
       " ['20-26k'],\n",
       " ['20-35k'],\n",
       " ['20-40k', '14'],\n",
       " ['12-20k', '13'],\n",
       " ['12-20k'],\n",
       " ['15-20k'],\n",
       " ['20-40k'],\n",
       " ['25-40k', '13'],\n",
       " ['12-16k', '22'],\n",
       " ['11-20k'],\n",
       " ['12-20k'],\n",
       " ['20-30k'],\n",
       " ['25-40k'],\n",
       " ['11-20k'],\n",
       " ['15-30k', '14'],\n",
       " ['20-40k', '13'],\n",
       " ['20-30k'],\n",
       " ['20-30k', '13'],\n",
       " ['25-55k'],\n",
       " ['30-60k', '14'],\n",
       " ['18-35k', '15'],\n",
       " ['20-30k'],\n",
       " ['12-20k'],\n",
       " ['25-35k'],\n",
       " ['30-45k', '14'],\n",
       " ['15-30k', '14'],\n",
       " ['25-35k'],\n",
       " ['15-30k'],\n",
       " ['15-25k'],\n",
       " ['20-30k', '18'],\n",
       " ['30-60k'],\n",
       " ['12-18k', '13'],\n",
       " ['15-25k', '14'],\n",
       " ['20-40k', '24'],\n",
       " ['18-26k', '13'],\n",
       " ['25-35k'],\n",
       " ['20-40k'],\n",
       " ['18-25k', '13'],\n",
       " ['20-25k'],\n",
       " ['21-26k'],\n",
       " ['15-25k'],\n",
       " ['18-30k'],\n",
       " ['15-18k'],\n",
       " ['20-40k'],\n",
       " ['21-26k'],\n",
       " ['20-30k', '16'],\n",
       " ['18-25k'],\n",
       " ['8-12k', '13'],\n",
       " ['15-18k'],\n",
       " ['18-30k', '13'],\n",
       " ['20-25k'],\n",
       " ['15-25k'],\n",
       " ['20-35k'],\n",
       " ['40-65k', '16'],\n",
       " ['15-25k'],\n",
       " ['12-16k', '18'],\n",
       " ['12-16k', '18'],\n",
       " ['20-30k', '13'],\n",
       " ['15-30k'],\n",
       " ['20-30k'],\n",
       " ['20-25k'],\n",
       " ['50-60k'],\n",
       " ['18-25k', '14'],\n",
       " ['20-40k', '14'],\n",
       " ['25-40k'],\n",
       " ['15-25k'],\n",
       " ['27-40k'],\n",
       " ['20-30k'],\n",
       " ['25-35k'],\n",
       " ['15-25k', '13'],\n",
       " ['15-30k', '15'],\n",
       " ['25-40k', '14'],\n",
       " ['15-25k'],\n",
       " ['20-30k'],\n",
       " ['18-25k'],\n",
       " ['13-19k', '15'],\n",
       " ['15-25k'],\n",
       " ['12-15k', '13'],\n",
       " ['20-25k'],\n",
       " ['16-25k', '13'],\n",
       " ['25-35k'],\n",
       " ['10-15k', '13'],\n",
       " ['25-40k', '16'],\n",
       " ['8-16k', '18'],\n",
       " ['20-30k', '15'],\n",
       " ['18-22k'],\n",
       " ['18-22k'],\n",
       " ['25-50k', '16'],\n",
       " ['20-30k'],\n",
       " ['20-30k', '14'],\n",
       " ['18-28k', '13'],\n",
       " ['20-30k'],\n",
       " ['12-18k'],\n",
       " ['16-25k'],\n",
       " ['16-22k', '13'],\n",
       " ['25-30k'],\n",
       " ['18-25k'],\n",
       " ['16-25k', '14'],\n",
       " ['12-20k'],\n",
       " ['15-22k'],\n",
       " ['18-30k'],\n",
       " ['15-20k'],\n",
       " ['15-25k', '15'],\n",
       " ['15-30k'],\n",
       " ['20-40k'],\n",
       " ['15-18k'],\n",
       " ['20-50k', '15'],\n",
       " ['15-25k'],\n",
       " ['15-26k'],\n",
       " ['18-35k', '16'],\n",
       " ['15-30k', '13'],\n",
       " ['20-30k'],\n",
       " ['25-35k'],\n",
       " ['15-25k'],\n",
       " ['60-70k'],\n",
       " ['20-40k', '14'],\n",
       " ['18-35k'],\n",
       " ['25-50k'],\n",
       " ['10-20k'],\n",
       " ['25-35k', '13'],\n",
       " ['20-30k', '13'],\n",
       " ['8-13k'],\n",
       " ['15-22k', '14'],\n",
       " ['20-30k'],\n",
       " ['20-30k'],\n",
       " ['15-25k', '14'],\n",
       " ['8-12k', '13'],\n",
       " ['15-20k'],\n",
       " ['20-40k', '13'],\n",
       " ['25-30k', '17'],\n",
       " ['25-40k'],\n",
       " ['18-30k'],\n",
       " ['25-35k'],\n",
       " ['25-50k', '13'],\n",
       " ['25-40k', '16'],\n",
       " ['15-20k', '13'],\n",
       " ['28-50k', '14'],\n",
       " ['11-18k', '13'],\n",
       " ['30-50k', '13'],\n",
       " ['10-12k'],\n",
       " ['35-55k'],\n",
       " ['18-25k'],\n",
       " ['15-30k', '13'],\n",
       " ['9-14k'],\n",
       " ['13-26k', '24'],\n",
       " ['17-22k', '13'],\n",
       " ['15-20k', '19'],\n",
       " ['15-30k', '13'],\n",
       " ['10-30k'],\n",
       " ['25-35k', '14'],\n",
       " ['11-23k', '13'],\n",
       " ['15-25k', '17'],\n",
       " ['15-20k'],\n",
       " ['50-80k'],\n",
       " ['10-15k'],\n",
       " ['15-25k'],\n",
       " ['18-25k'],\n",
       " ['20-40k'],\n",
       " ['20-40k', '14'],\n",
       " ['20-40k', '24'],\n",
       " ['12-22k', '13'],\n",
       " ['10-12k'],\n",
       " ['15-20k'],\n",
       " ['20-30k', '13'],\n",
       " ['12-20k'],\n",
       " ['30-45k', '14'],\n",
       " ['20-40k'],\n",
       " ['18-35k'],\n",
       " ['20-25k'],\n",
       " ['25-35k'],\n",
       " ['10-20k'],\n",
       " ['6-11k'],\n",
       " ['10-30k'],\n",
       " ['10-20k'],\n",
       " ['14-15k'],\n",
       " ['20-30k'],\n",
       " ['15-20k', '13'],\n",
       " ['20-30k'],\n",
       " ['30-50k', '16'],\n",
       " ['20-35k', '14'],\n",
       " ['20-35k'],\n",
       " ['19-25k'],\n",
       " ['20-40k'],\n",
       " ['20-25k'],\n",
       " ['12-20k'],\n",
       " ['15-20k'],\n",
       " ['25-40k'],\n",
       " ['20-30k'],\n",
       " ['25-30k'],\n",
       " ['12-20k'],\n",
       " ['15-20k'],\n",
       " ['15-25k', '13'],\n",
       " ['25-35k'],\n",
       " ['15-30k'],\n",
       " ['13-20k'],\n",
       " ['25-35k'],\n",
       " ['18-35k'],\n",
       " ['15-30k', '15'],\n",
       " ['30-60k', '16'],\n",
       " ['25-35k', '16'],\n",
       " ['15-25k'],\n",
       " ['10-15k', '13'],\n",
       " ['12-25k', '13'],\n",
       " ['20-35k', '13'],\n",
       " ['30-40k', '16'],\n",
       " ['9-20k'],\n",
       " ['15-25k'],\n",
       " ['20-40k'],\n",
       " ['15-25k'],\n",
       " ['25-30k'],\n",
       " ['20-40k', '14'],\n",
       " ['15-25k']]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "非薪资面议_detail = 非薪资面议['job.salary'].apply(lambda x:x.split('薪')[0].split('·')).tolist()\n",
    "非薪资面议_detail"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "cf481588",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[21.5,\n",
       " 30.0,\n",
       " 16.9,\n",
       " 32.5,\n",
       " 25.0,\n",
       " 40.0,\n",
       " 35.0,\n",
       " 24.4,\n",
       " 25.0,\n",
       " 56.2,\n",
       " 33.8,\n",
       " 24.0,\n",
       " 21.0,\n",
       " 28.0,\n",
       " 32.1,\n",
       " 40.6,\n",
       " 19.0,\n",
       " 37.5,\n",
       " 20.0,\n",
       " 16.5,\n",
       " 29.2,\n",
       " 29.2,\n",
       " 24.4,\n",
       " 16.2,\n",
       " 35.0,\n",
       " 14.0,\n",
       " 30.0,\n",
       " 30.0,\n",
       " 30.0,\n",
       " 30.0,\n",
       " 18.0,\n",
       " 19.0,\n",
       " 30.0,\n",
       " 22.5,\n",
       " 25.1,\n",
       " 25.0,\n",
       " 29.2,\n",
       " 17.5,\n",
       " 17.5,\n",
       " 27.1,\n",
       " 17.0,\n",
       " 14.0,\n",
       " 16.0,\n",
       " 19.5,\n",
       " 20.0,\n",
       " 12.5,\n",
       " 20.0,\n",
       " 30.0,\n",
       " 20.0,\n",
       " 32.5,\n",
       " 45.0,\n",
       " 25.1,\n",
       " 16.8,\n",
       " 30.0,\n",
       " 21.6,\n",
       " 25.0,\n",
       " 46.0,\n",
       " 32.5,\n",
       " 35.0,\n",
       " 32.5,\n",
       " 35.0,\n",
       " 35.0,\n",
       " 35.0,\n",
       " 22.5,\n",
       " 35.0,\n",
       " 17.3,\n",
       " 16.0,\n",
       " 25.0,\n",
       " 13.5,\n",
       " 46.7,\n",
       " 35.0,\n",
       " 35.0,\n",
       " 23.3,\n",
       " 22.5,\n",
       " 35.0,\n",
       " 30.0,\n",
       " 16.0,\n",
       " 30.0,\n",
       " 40.0,\n",
       " 22.5,\n",
       " 25.0,\n",
       " 22.5,\n",
       " 22.5,\n",
       " 22.5,\n",
       " 16.0,\n",
       " 16.0,\n",
       " 52.5,\n",
       " 24.4,\n",
       " 30.9,\n",
       " 22.5,\n",
       " 30.0,\n",
       " 11.5,\n",
       " 30.0,\n",
       " 22.5,\n",
       " 30.0,\n",
       " 32.5,\n",
       " 17.5,\n",
       " 17.5,\n",
       " 22.5,\n",
       " 16.0,\n",
       " 14.6,\n",
       " 21.5,\n",
       " 11.0,\n",
       " 29.2,\n",
       " 27.5,\n",
       " 35.2,\n",
       " 22.5,\n",
       " 11.0,\n",
       " 21.5,\n",
       " 14.0,\n",
       " 14.0,\n",
       " 17.5,\n",
       " 24.4,\n",
       " 30.0,\n",
       " 16.0,\n",
       " 22.5,\n",
       " 17.5,\n",
       " 20.0,\n",
       " 24.4,\n",
       " 32.1,\n",
       " 37.9,\n",
       " 21.2,\n",
       " 35.0,\n",
       " 27.4,\n",
       " 35.0,\n",
       " 30.0,\n",
       " 21.7,\n",
       " 17.5,\n",
       " 35.2,\n",
       " 27.1,\n",
       " 25.0,\n",
       " 34.4,\n",
       " 30.0,\n",
       " 25.0,\n",
       " 25.0,\n",
       " 25.0,\n",
       " 22.5,\n",
       " 32.1,\n",
       " 22.5,\n",
       " 23.3,\n",
       " 24.9,\n",
       " 30.0,\n",
       " 55.0,\n",
       " 27.5,\n",
       " 35.2,\n",
       " 30.0,\n",
       " 46.7,\n",
       " 23.0,\n",
       " 27.5,\n",
       " 35.0,\n",
       " 17.3,\n",
       " 16.0,\n",
       " 17.5,\n",
       " 30.0,\n",
       " 35.2,\n",
       " 25.7,\n",
       " 15.5,\n",
       " 16.0,\n",
       " 25.0,\n",
       " 32.5,\n",
       " 15.5,\n",
       " 26.2,\n",
       " 32.5,\n",
       " 25.0,\n",
       " 27.1,\n",
       " 40.0,\n",
       " 52.5,\n",
       " 33.1,\n",
       " 25.0,\n",
       " 16.0,\n",
       " 30.0,\n",
       " 43.8,\n",
       " 26.2,\n",
       " 30.0,\n",
       " 22.5,\n",
       " 20.0,\n",
       " 37.5,\n",
       " 45.0,\n",
       " 16.2,\n",
       " 23.3,\n",
       " 60.0,\n",
       " 23.8,\n",
       " 30.0,\n",
       " 30.0,\n",
       " 23.3,\n",
       " 22.5,\n",
       " 23.5,\n",
       " 20.0,\n",
       " 24.0,\n",
       " 16.5,\n",
       " 30.0,\n",
       " 23.5,\n",
       " 33.3,\n",
       " 21.5,\n",
       " 10.8,\n",
       " 16.5,\n",
       " 26.0,\n",
       " 22.5,\n",
       " 20.0,\n",
       " 27.5,\n",
       " 70.0,\n",
       " 20.0,\n",
       " 21.0,\n",
       " 21.0,\n",
       " 27.1,\n",
       " 22.5,\n",
       " 25.0,\n",
       " 22.5,\n",
       " 55.0,\n",
       " 25.1,\n",
       " 35.0,\n",
       " 32.5,\n",
       " 20.0,\n",
       " 33.5,\n",
       " 25.0,\n",
       " 30.0,\n",
       " 21.7,\n",
       " 28.1,\n",
       " 37.9,\n",
       " 20.0,\n",
       " 25.0,\n",
       " 21.5,\n",
       " 20.0,\n",
       " 20.0,\n",
       " 14.6,\n",
       " 22.5,\n",
       " 22.2,\n",
       " 30.0,\n",
       " 13.5,\n",
       " 43.3,\n",
       " 18.0,\n",
       " 31.2,\n",
       " 20.0,\n",
       " 20.0,\n",
       " 50.0,\n",
       " 25.0,\n",
       " 29.2,\n",
       " 24.9,\n",
       " 25.0,\n",
       " 15.0,\n",
       " 20.5,\n",
       " 20.6,\n",
       " 27.5,\n",
       " 21.5,\n",
       " 23.9,\n",
       " 16.0,\n",
       " 18.5,\n",
       " 24.0,\n",
       " 17.5,\n",
       " 25.0,\n",
       " 22.5,\n",
       " 30.0,\n",
       " 16.5,\n",
       " 43.8,\n",
       " 20.0,\n",
       " 20.5,\n",
       " 35.3,\n",
       " 24.4,\n",
       " 25.0,\n",
       " 30.0,\n",
       " 20.0,\n",
       " 65.0,\n",
       " 35.0,\n",
       " 26.5,\n",
       " 37.5,\n",
       " 15.0,\n",
       " 32.5,\n",
       " 27.1,\n",
       " 10.5,\n",
       " 21.6,\n",
       " 25.0,\n",
       " 25.0,\n",
       " 23.3,\n",
       " 10.8,\n",
       " 17.5,\n",
       " 32.5,\n",
       " 39.0,\n",
       " 32.5,\n",
       " 24.0,\n",
       " 30.0,\n",
       " 40.6,\n",
       " 43.3,\n",
       " 19.0,\n",
       " 45.5,\n",
       " 15.7,\n",
       " 43.3,\n",
       " 11.0,\n",
       " 45.0,\n",
       " 21.5,\n",
       " 24.4,\n",
       " 11.5,\n",
       " 39.0,\n",
       " 21.1,\n",
       " 27.7,\n",
       " 24.4,\n",
       " 20.0,\n",
       " 35.0,\n",
       " 18.4,\n",
       " 28.3,\n",
       " 17.5,\n",
       " 65.0,\n",
       " 12.5,\n",
       " 20.0,\n",
       " 21.5,\n",
       " 30.0,\n",
       " 35.0,\n",
       " 60.0,\n",
       " 18.4,\n",
       " 11.0,\n",
       " 17.5,\n",
       " 27.1,\n",
       " 16.0,\n",
       " 43.8,\n",
       " 30.0,\n",
       " 26.5,\n",
       " 22.5,\n",
       " 30.0,\n",
       " 15.0,\n",
       " 8.5,\n",
       " 20.0,\n",
       " 15.0,\n",
       " 14.5,\n",
       " 25.0,\n",
       " 19.0,\n",
       " 25.0,\n",
       " 53.3,\n",
       " 32.1,\n",
       " 27.5,\n",
       " 22.0,\n",
       " 30.0,\n",
       " 22.5,\n",
       " 16.0,\n",
       " 17.5,\n",
       " 32.5,\n",
       " 25.0,\n",
       " 27.5,\n",
       " 16.0,\n",
       " 17.5,\n",
       " 21.7,\n",
       " 30.0,\n",
       " 22.5,\n",
       " 16.5,\n",
       " 30.0,\n",
       " 26.5,\n",
       " 28.1,\n",
       " 60.0,\n",
       " 40.0,\n",
       " 20.0,\n",
       " 13.5,\n",
       " 20.0,\n",
       " 29.8,\n",
       " 46.7,\n",
       " 14.5,\n",
       " 20.0,\n",
       " 30.0,\n",
       " 20.0,\n",
       " 27.5,\n",
       " 35.0,\n",
       " 20.0]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "平均薪资 = [ (int(i[0].split('-')[0]) +int(i[0].split('-')[1].split('k')[0]))/2    \\\n",
    " if len(i)==1 else round((int(i[0].split('-')[0]) +int(i[0].split('-')[1].split('k')[0]))/2*int(i[1])/12,1)     \\\n",
    " for i in 非薪资面议_detail        ] \n",
    "平均薪资"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "dbe1802f",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\86135\\AppData\\Local\\Temp\\ipykernel_6472\\3673931196.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  非薪资面议['平均薪资']=平均薪资\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>job.labels</th>\n",
       "      <th>job.refreshTime</th>\n",
       "      <th>job.title</th>\n",
       "      <th>job.salary</th>\n",
       "      <th>job.dq</th>\n",
       "      <th>job.topJob</th>\n",
       "      <th>job.requireWorkYears</th>\n",
       "      <th>job.requireEduLevel</th>\n",
       "      <th>comp.compStage</th>\n",
       "      <th>comp.compName</th>\n",
       "      <th>comp.compIndustry</th>\n",
       "      <th>comp.compScale</th>\n",
       "      <th>平均薪资</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>[商品企划, 数据分析, 产品规划, 波段管理, 成本分析]</td>\n",
       "      <td>20231107105852</td>\n",
       "      <td>商品企划经理</td>\n",
       "      <td>18-25k</td>\n",
       "      <td>广州</td>\n",
       "      <td>True</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>大专</td>\n",
       "      <td>NaN</td>\n",
       "      <td>广州迪柯尼服饰股份有限公司</td>\n",
       "      <td>服装/纺织/皮革</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>21.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>[工具产品, 安全产品, 客户端产品, 交通/运输/物流, 汽车行业, 自动驾驶, 产品优化...</td>\n",
       "      <td>20231025170441</td>\n",
       "      <td>自动驾驶产品经理（PM）</td>\n",
       "      <td>25-35k</td>\n",
       "      <td>广州-海珠区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>D轮</td>\n",
       "      <td>文远知行WeRide</td>\n",
       "      <td>人工智能</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>[神外, 医生]</td>\n",
       "      <td>20230428143658</td>\n",
       "      <td>神外产品销售经理 Product Sales Manager</td>\n",
       "      <td>12-15k·15薪</td>\n",
       "      <td>广州-越秀区</td>\n",
       "      <td>False</td>\n",
       "      <td>1-3年</td>\n",
       "      <td>统招本科</td>\n",
       "      <td>已上市</td>\n",
       "      <td>复星医药集团</td>\n",
       "      <td>制药</td>\n",
       "      <td>10000人以上</td>\n",
       "      <td>16.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>[]</td>\n",
       "      <td>20230626175056</td>\n",
       "      <td>Automation Product Manager</td>\n",
       "      <td>20-40k·13薪</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>False</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>本科</td>\n",
       "      <td>NaN</td>\n",
       "      <td>丹纳赫</td>\n",
       "      <td>医疗器械</td>\n",
       "      <td>5000-10000人</td>\n",
       "      <td>32.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>[全国市场管理]</td>\n",
       "      <td>20231108141556</td>\n",
       "      <td>全国市务经理</td>\n",
       "      <td>20-30k</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>False</td>\n",
       "      <td>10年以上</td>\n",
       "      <td>本科</td>\n",
       "      <td>NaN</td>\n",
       "      <td>捷荣食品</td>\n",
       "      <td>食品/饮料/酒水</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>25.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>[数据产品, 策略产品, 数据分析, 产品设计, 需求分析, 用户研究, 产品规划]</td>\n",
       "      <td>20230907142342</td>\n",
       "      <td>高级产品经理（数据方向）</td>\n",
       "      <td>20-40k</td>\n",
       "      <td>广州-海珠区</td>\n",
       "      <td>False</td>\n",
       "      <td>5-10年</td>\n",
       "      <td>本科</td>\n",
       "      <td>NaN</td>\n",
       "      <td>某广州IT服务公司</td>\n",
       "      <td>IT服务</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>30.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>[SaaS产品, to B, 人事系统, HRM系统, HR模块, 人才发展, 培训, 招聘...</td>\n",
       "      <td>20231108090734</td>\n",
       "      <td>产品经理（人事系统）</td>\n",
       "      <td>15-25k</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>大专</td>\n",
       "      <td>NaN</td>\n",
       "      <td>博纳德集团</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>[小家电, 厨卫电器, 保健电器, 取暖电器, 制冷电器, 个护电器, 饮水电器, 生命周期...</td>\n",
       "      <td>20231016142930</td>\n",
       "      <td>资深硬件产品经理</td>\n",
       "      <td>25-30k</td>\n",
       "      <td>广州-番禺区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>大专</td>\n",
       "      <td>NaN</td>\n",
       "      <td>火猩未来</td>\n",
       "      <td>电子商务</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>27.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>[ppt, 架构设计, axure, visio, xmind, 数据分析]</td>\n",
       "      <td>20230704162107</td>\n",
       "      <td>高级WMS产品经理 (MJ003186)</td>\n",
       "      <td>20-40k·14薪</td>\n",
       "      <td>广州-番禺区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>大专</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SHEIN</td>\n",
       "      <td>互联网</td>\n",
       "      <td>5000-10000人</td>\n",
       "      <td>35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>[后台产品, 数据产品, IT互联网, to B, 产品设计, 产品规划, 用户研究]</td>\n",
       "      <td>20231108135824</td>\n",
       "      <td>HRM产品经理</td>\n",
       "      <td>15-25k</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>False</td>\n",
       "      <td>3-5年</td>\n",
       "      <td>大专</td>\n",
       "      <td>NaN</td>\n",
       "      <td>博纳德集团</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>500-999人</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>359 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           job.labels job.refreshTime  \\\n",
       "0                      [商品企划, 数据分析, 产品规划, 波段管理, 成本分析]  20231107105852   \n",
       "4   [工具产品, 安全产品, 客户端产品, 交通/运输/物流, 汽车行业, 自动驾驶, 产品优化...  20231025170441   \n",
       "6                                            [神外, 医生]  20230428143658   \n",
       "8                                                  []  20230626175056   \n",
       "9                                            [全国市场管理]  20231108141556   \n",
       "..                                                ...             ...   \n",
       "34         [数据产品, 策略产品, 数据分析, 产品设计, 需求分析, 用户研究, 产品规划]  20230907142342   \n",
       "35  [SaaS产品, to B, 人事系统, HRM系统, HR模块, 人才发展, 培训, 招聘...  20231108090734   \n",
       "36  [小家电, 厨卫电器, 保健电器, 取暖电器, 制冷电器, 个护电器, 饮水电器, 生命周期...  20231016142930   \n",
       "38             [ppt, 架构设计, axure, visio, xmind, 数据分析]  20230704162107   \n",
       "39        [后台产品, 数据产品, IT互联网, to B, 产品设计, 产品规划, 用户研究]  20231108135824   \n",
       "\n",
       "                         job.title  job.salary  job.dq  job.topJob  \\\n",
       "0                           商品企划经理      18-25k      广州        True   \n",
       "4                     自动驾驶产品经理（PM）      25-35k  广州-海珠区       False   \n",
       "6   神外产品销售经理 Product Sales Manager  12-15k·15薪  广州-越秀区       False   \n",
       "8       Automation Product Manager  20-40k·13薪  广州-天河区       False   \n",
       "9                           全国市务经理      20-30k  广州-天河区       False   \n",
       "..                             ...         ...     ...         ...   \n",
       "34                    高级产品经理（数据方向）      20-40k  广州-海珠区       False   \n",
       "35                      产品经理（人事系统）      15-25k  广州-天河区       False   \n",
       "36                        资深硬件产品经理      25-30k  广州-番禺区       False   \n",
       "38            高级WMS产品经理 (MJ003186)  20-40k·14薪  广州-番禺区       False   \n",
       "39                         HRM产品经理      15-25k  广州-天河区       False   \n",
       "\n",
       "   job.requireWorkYears job.requireEduLevel comp.compStage  comp.compName  \\\n",
       "0                 5-10年                  大专            NaN  广州迪柯尼服饰股份有限公司   \n",
       "4                  3-5年                统招本科             D轮     文远知行WeRide   \n",
       "6                  1-3年                统招本科            已上市         复星医药集团   \n",
       "8                 5-10年                  本科            NaN            丹纳赫   \n",
       "9                 10年以上                  本科            NaN           捷荣食品   \n",
       "..                  ...                 ...            ...            ...   \n",
       "34                5-10年                  本科            NaN      某广州IT服务公司   \n",
       "35                 3-5年                  大专            NaN          博纳德集团   \n",
       "36                 3-5年                  大专            NaN           火猩未来   \n",
       "38                 3-5年                  大专            NaN          SHEIN   \n",
       "39                 3-5年                  大专            NaN          博纳德集团   \n",
       "\n",
       "   comp.compIndustry comp.compScale  平均薪资  \n",
       "0           服装/纺织/皮革       500-999人  21.5  \n",
       "4               人工智能       100-499人  30.0  \n",
       "6                 制药       10000人以上  16.9  \n",
       "8               医疗器械    5000-10000人  32.5  \n",
       "9           食品/饮料/酒水       100-499人  25.0  \n",
       "..               ...            ...   ...  \n",
       "34              IT服务       100-499人  30.0  \n",
       "35             计算机软件       500-999人  20.0  \n",
       "36              电子商务         50-99人  27.5  \n",
       "38               互联网    5000-10000人  35.0  \n",
       "39             计算机软件       500-999人  20.0  \n",
       "\n",
       "[359 rows x 13 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "非薪资面议['平均薪资']=平均薪资\n",
    "非薪资面议"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "00e39cf5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>平均薪资</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>job.requireWorkYears</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1-3年</th>\n",
       "      <td>17.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10年以上</th>\n",
       "      <td>29.2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3-5年</th>\n",
       "      <td>23.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5-10年</th>\n",
       "      <td>27.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>一年以下</th>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      平均薪资\n",
       "job.requireWorkYears      \n",
       "1-3年                  17.5\n",
       "10年以上                 29.2\n",
       "3-5年                  23.3\n",
       "5-10年                 27.1\n",
       "一年以下                  20.0"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 分工作年限平均薪资\n",
    "分年限_平均薪资 = 非薪资面议.groupby('job.requireWorkYears').agg({'平均薪资':'median'})\n",
    "分年限_平均薪资"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "3d414b8a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>平均薪资</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>job.requireWorkYears</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>一年以下</th>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1-3年</th>\n",
       "      <td>17.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3-5年</th>\n",
       "      <td>23.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5-10年</th>\n",
       "      <td>27.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10年以上</th>\n",
       "      <td>29.2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                      平均薪资\n",
       "job.requireWorkYears      \n",
       "一年以下                  20.0\n",
       "1-3年                  17.5\n",
       "3-5年                  23.3\n",
       "5-10年                 27.1\n",
       "10年以上                 29.2"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "年限 = 分年限_平均薪资.reindex(index=[\"一年以下\",\"1-3年\",\"3-5年\",\"5-10年\",\"10年以上\"])\n",
    "年限"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "b42fa24f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[20.0, 17.5, 23.3, 27.1, 29.2]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "分年限_平均薪资_values = [round(i[0], 1) for i in 年限.values.tolist()]\n",
    "分年限_平均薪资_values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "d586f464",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['一年以下', '1-3年', '3-5年', '5-10年', '10年以上']"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "分年限_平均薪资_index = 年限.index.tolist()\n",
    "分年限_平均薪资_index"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0eca3a2a",
   "metadata": {},
   "source": [
    "# 词云图"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "340549fe",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0                          商品企划经理\n",
       "1                            产品经理\n",
       "2                        产品经理（B端）\n",
       "3     产品经理（化妆品原料）/Product Manager\n",
       "4                    自动驾驶产品经理（PM）\n",
       "                 ...             \n",
       "35                     产品经理（人事系统）\n",
       "36                       资深硬件产品经理\n",
       "37                      网络金融部产品经理\n",
       "38           高级WMS产品经理 (MJ003186)\n",
       "39                        HRM产品经理\n",
       "Name: job.title, Length: 400, dtype: object"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    " df_PM_gz['job.title']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "fc8edf31",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2         产品经理\n",
       "3         产品经理\n",
       "4     自动驾驶产品经理\n",
       "14        产品经理\n",
       "19        产品经理\n",
       "        ...   \n",
       "27        产品经理\n",
       "28        产品经理\n",
       "32        产品经理\n",
       "34      高级产品经理\n",
       "35        产品经理\n",
       "Name: job.title, Length: 127, dtype: object"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 还要合并回去原来的行\n",
    "df_PM_gz['job.title'][   df_PM_gz['job.title'].str.contains('（')   ].str.split('（').apply(lambda x:x[0])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "75c812d4",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "产品经理            142\n",
       "高级产品经理           41\n",
       "助理产品经理            9\n",
       "医药产品经理            5\n",
       "软件产品经理            5\n",
       "               ... \n",
       "产品经理 - 数字化运营      1\n",
       "朗特产品经理            1\n",
       "中级产品经理            1\n",
       "                  1\n",
       "高级WMS产品经理         1\n",
       "Name: job.title, Length: 155, dtype: int64"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 处理过一些，清洗后的数据\n",
    "df_job_title = df_PM_gz['job.title'].apply(lambda x:x.split('（')[0].split('/')[0].split('(')[0]).value_counts()\n",
    "df_job_title"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "a2da302c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['产品经理',\n",
       " '高级产品经理',\n",
       " '助理产品经理',\n",
       " '医药产品经理',\n",
       " '软件产品经理',\n",
       " '硬件产品经理',\n",
       " '区域产品经理',\n",
       " '智能硬件产品经理',\n",
       " '产品经理-热泵',\n",
       " 'AI产品经理',\n",
       " '电商产品经理',\n",
       " '高级',\n",
       " '金融产品经理',\n",
       " '产品策划经理',\n",
       " '产业金融产品经理',\n",
       " '物联网产品经理',\n",
       " 'B端产品经理',\n",
       " '数据产品经理',\n",
       " '华侨金融产品经理',\n",
       " 'AIGC产品经理',\n",
       " '中高级产品经理',\n",
       " '中后台产品经理',\n",
       " '资深产品经理',\n",
       " '跨境电商产品经理',\n",
       " '肾线产品经理',\n",
       " '海外产品经理',\n",
       " '大数据产品经理',\n",
       " 'Oral Product Manager',\n",
       " '自动驾驶产品经理',\n",
       " '资深硬件产品经理',\n",
       " 'IOT产品经理',\n",
       " 'HRM产品经理',\n",
       " 'OTC产品经理',\n",
       " 'CRM产品经理',\n",
       " '高级数据产品经理',\n",
       " '产品经理【数据算法类】',\n",
       " 'OMS产品经理',\n",
       " 'b端产品经理',\n",
       " '运营商BU-产品经理-广州',\n",
       " 'OS产品经理',\n",
       " '智能运维产品经理',\n",
       " '工具规划产品经理',\n",
       " '总行国际业务产品经理',\n",
       " '平台产品经理',\n",
       " '服装产品经理',\n",
       " '产品高级经理',\n",
       " '中高级app产品经理',\n",
       " 'SAP FICO',\n",
       " '产品经理——央企',\n",
       " '高级产品经理【支付经验】',\n",
       " '总行产业金融产品经理',\n",
       " 'C端产品经理',\n",
       " '直播产品经理',\n",
       " '水家电产品经理',\n",
       " '财务产品经理',\n",
       " '商品企划经理',\n",
       " '营销线IT产品经理',\n",
       " '卫品产品经理',\n",
       " '床垫产品经理',\n",
       " '创新产品经理',\n",
       " '新能源产品经理 ',\n",
       " '产品经理 ',\n",
       " '市场部产品经理',\n",
       " 'PTBU-产品经理',\n",
       " '代客代理中心产品经理岗',\n",
       " '基层产品经理',\n",
       " '广花融资担保公司',\n",
       " '产品经理岗',\n",
       " 'Saas产品经理',\n",
       " '全屋照明产品经理',\n",
       " '标注系统产品经理',\n",
       " '广告产品经理 ',\n",
       " '网络金融部产品经理',\n",
       " '支付产品经理',\n",
       " '旅游产品经理',\n",
       " '高级产品经理 ',\n",
       " 'App产品经理',\n",
       " 'AI高级产品经理',\n",
       " 'c端产品经理',\n",
       " 'HR产品经理',\n",
       " 'c端高级产品经理',\n",
       " '管道产品经理',\n",
       " 'GTM经理',\n",
       " '密码产品经理',\n",
       " '视频云产品经理',\n",
       " '自动化产品经理',\n",
       " '物流产品经理',\n",
       " '互联网金融产品经理',\n",
       " '教育',\n",
       " '产品经理【结算类】',\n",
       " '智慧环保产品经理',\n",
       " '产品经理-肿瘤',\n",
       " '电网调度自动化产品经理',\n",
       " '融资业务副经理',\n",
       " '游戏PM',\n",
       " '高级医药产品经理',\n",
       " 'CoAI产品经理',\n",
       " '金融科技产品经理岗',\n",
       " '高级TMS产品经理 ',\n",
       " '策略产品经理 ',\n",
       " 'ERP产品经理',\n",
       " '低空产品经理',\n",
       " 'IT产品经理',\n",
       " '供应链产品经理',\n",
       " '解决方案产品经理 ',\n",
       " '初级产品经理',\n",
       " '临床试验项目经理PM',\n",
       " '央企子公司-产品经理',\n",
       " 'CRM实施顾问&项目经理PM',\n",
       " '002密码产品经理',\n",
       " '微生物检测产品销售经理',\n",
       " 'Product Manager - 家电，厨具',\n",
       " 'Data Platform Product Manager',\n",
       " '产品经理-产品企划',\n",
       " '数码产品经理',\n",
       " '产品经理-汽车车身电子域控',\n",
       " 'Global Product Manager Trainee  ',\n",
       " 'AIGC营销产品经理',\n",
       " '全国市务经理',\n",
       " 'Automation Product Manager',\n",
       " 'CT 产品销售经理 广州',\n",
       " '神外产品销售经理 Product Sales Manager',\n",
       " '口腔护理产品经理',\n",
       " '人脸产品经理',\n",
       " '研究所数字化产品经理',\n",
       " 'COAI产品经理',\n",
       " '投资交易业务系统产品经理',\n",
       " '社交产品经理',\n",
       " 'MES产品经理',\n",
       " '热泵产品经理',\n",
       " '产品经理--TOP TOY',\n",
       " '衍生品产品经理',\n",
       " '小家电产品经理 ',\n",
       " '#高级产品经理',\n",
       " '渠道数字化产品经理',\n",
       " '产品经理-财务方向',\n",
       " '产品经理 国企',\n",
       " 'IT PM',\n",
       " '家电、热泵 产品经理',\n",
       " '市场产品经理',\n",
       " '日化产品经理',\n",
       " '产品经理 C端',\n",
       " '智能座舱产品经理',\n",
       " '安全产品经理',\n",
       " '·高级产品经理',\n",
       " 'B端产品经理-Java开发转产品-港资直销公司',\n",
       " '后台产品经理',\n",
       " '产品助理',\n",
       " '家具产品经理',\n",
       " 'app产品经理',\n",
       " '产品经理 - 数字化运营',\n",
       " '朗特产品经理',\n",
       " '中级产品经理',\n",
       " '',\n",
       " '高级WMS产品经理 ']"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_job_title.index.tolist()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "81680d4c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('高级产品经理', 41),\n",
       " ('助理产品经理', 9),\n",
       " ('医药产品经理', 5),\n",
       " ('软件产品经理', 5),\n",
       " ('硬件产品经理', 5),\n",
       " ('区域产品经理', 4),\n",
       " ('智能硬件产品经理', 4),\n",
       " ('产品经理-热泵', 4),\n",
       " ('AI产品经理', 4),\n",
       " ('电商产品经理', 3),\n",
       " ('高级', 3),\n",
       " ('金融产品经理', 3),\n",
       " ('产品策划经理', 3),\n",
       " ('产业金融产品经理', 3),\n",
       " ('物联网产品经理', 3),\n",
       " ('B端产品经理', 3),\n",
       " ('数据产品经理', 2),\n",
       " ('华侨金融产品经理', 2),\n",
       " ('AIGC产品经理', 2),\n",
       " ('中高级产品经理', 2),\n",
       " ('中后台产品经理', 2),\n",
       " ('资深产品经理', 2),\n",
       " ('跨境电商产品经理', 2),\n",
       " ('肾线产品经理', 2),\n",
       " ('海外产品经理', 2),\n",
       " ('大数据产品经理', 2),\n",
       " ('Oral Product Manager', 2),\n",
       " ('自动驾驶产品经理', 2),\n",
       " ('资深硬件产品经理', 2),\n",
       " ('IOT产品经理', 2),\n",
       " ('HRM产品经理', 2),\n",
       " ('OTC产品经理', 2),\n",
       " ('CRM产品经理', 2),\n",
       " ('高级数据产品经理', 2),\n",
       " ('产品经理【数据算法类】', 1),\n",
       " ('OMS产品经理', 1),\n",
       " ('b端产品经理', 1),\n",
       " ('运营商BU-产品经理-广州', 1),\n",
       " ('OS产品经理', 1),\n",
       " ('智能运维产品经理', 1),\n",
       " ('工具规划产品经理', 1),\n",
       " ('总行国际业务产品经理', 1),\n",
       " ('平台产品经理', 1),\n",
       " ('服装产品经理', 1),\n",
       " ('产品高级经理', 1),\n",
       " ('中高级app产品经理', 1),\n",
       " ('SAP FICO', 1),\n",
       " ('产品经理——央企', 1),\n",
       " ('高级产品经理【支付经验】', 1),\n",
       " ('总行产业金融产品经理', 1),\n",
       " ('C端产品经理', 1),\n",
       " ('直播产品经理', 1),\n",
       " ('水家电产品经理', 1),\n",
       " ('财务产品经理', 1),\n",
       " ('商品企划经理', 1),\n",
       " ('营销线IT产品经理', 1),\n",
       " ('卫品产品经理', 1),\n",
       " ('床垫产品经理', 1),\n",
       " ('创新产品经理', 1),\n",
       " ('新能源产品经理 ', 1),\n",
       " ('产品经理 ', 1),\n",
       " ('市场部产品经理', 1),\n",
       " ('PTBU-产品经理', 1),\n",
       " ('代客代理中心产品经理岗', 1),\n",
       " ('基层产品经理', 1),\n",
       " ('广花融资担保公司', 1),\n",
       " ('产品经理岗', 1),\n",
       " ('Saas产品经理', 1),\n",
       " ('全屋照明产品经理', 1),\n",
       " ('标注系统产品经理', 1),\n",
       " ('广告产品经理 ', 1),\n",
       " ('网络金融部产品经理', 1),\n",
       " ('支付产品经理', 1),\n",
       " ('旅游产品经理', 1),\n",
       " ('高级产品经理 ', 1),\n",
       " ('App产品经理', 1),\n",
       " ('AI高级产品经理', 1),\n",
       " ('c端产品经理', 1),\n",
       " ('HR产品经理', 1),\n",
       " ('c端高级产品经理', 1),\n",
       " ('管道产品经理', 1),\n",
       " ('GTM经理', 1),\n",
       " ('密码产品经理', 1),\n",
       " ('视频云产品经理', 1),\n",
       " ('自动化产品经理', 1),\n",
       " ('物流产品经理', 1),\n",
       " ('互联网金融产品经理', 1),\n",
       " ('教育', 1),\n",
       " ('产品经理【结算类】', 1),\n",
       " ('智慧环保产品经理', 1),\n",
       " ('产品经理-肿瘤', 1),\n",
       " ('电网调度自动化产品经理', 1),\n",
       " ('融资业务副经理', 1),\n",
       " ('游戏PM', 1),\n",
       " ('高级医药产品经理', 1),\n",
       " ('CoAI产品经理', 1),\n",
       " ('金融科技产品经理岗', 1),\n",
       " ('高级TMS产品经理 ', 1),\n",
       " ('策略产品经理 ', 1),\n",
       " ('ERP产品经理', 1),\n",
       " ('低空产品经理', 1),\n",
       " ('IT产品经理', 1),\n",
       " ('供应链产品经理', 1),\n",
       " ('解决方案产品经理 ', 1),\n",
       " ('初级产品经理', 1),\n",
       " ('临床试验项目经理PM', 1),\n",
       " ('央企子公司-产品经理', 1),\n",
       " ('CRM实施顾问&项目经理PM', 1),\n",
       " ('002密码产品经理', 1),\n",
       " ('微生物检测产品销售经理', 1),\n",
       " ('Product Manager - 家电，厨具', 1),\n",
       " ('Data Platform Product Manager', 1),\n",
       " ('产品经理-产品企划', 1),\n",
       " ('数码产品经理', 1),\n",
       " ('产品经理-汽车车身电子域控', 1),\n",
       " ('Global Product Manager Trainee  ', 1),\n",
       " ('AIGC营销产品经理', 1),\n",
       " ('全国市务经理', 1),\n",
       " ('Automation Product Manager', 1),\n",
       " ('CT 产品销售经理 广州', 1),\n",
       " ('神外产品销售经理 Product Sales Manager', 1),\n",
       " ('口腔护理产品经理', 1),\n",
       " ('人脸产品经理', 1),\n",
       " ('研究所数字化产品经理', 1),\n",
       " ('COAI产品经理', 1),\n",
       " ('投资交易业务系统产品经理', 1),\n",
       " ('社交产品经理', 1),\n",
       " ('MES产品经理', 1),\n",
       " ('热泵产品经理', 1),\n",
       " ('产品经理--TOP TOY', 1),\n",
       " ('衍生品产品经理', 1),\n",
       " ('小家电产品经理 ', 1),\n",
       " ('#高级产品经理', 1),\n",
       " ('渠道数字化产品经理', 1),\n",
       " ('产品经理-财务方向', 1),\n",
       " ('产品经理 国企', 1),\n",
       " ('IT PM', 1),\n",
       " ('家电、热泵 产品经理', 1),\n",
       " ('市场产品经理', 1),\n",
       " ('日化产品经理', 1),\n",
       " ('产品经理 C端', 1),\n",
       " ('智能座舱产品经理', 1),\n",
       " ('安全产品经理', 1),\n",
       " ('·高级产品经理', 1),\n",
       " ('B端产品经理-Java开发转产品-港资直销公司', 1),\n",
       " ('后台产品经理', 1),\n",
       " ('产品助理', 1),\n",
       " ('家具产品经理', 1),\n",
       " ('app产品经理', 1),\n",
       " ('产品经理 - 数字化运营', 1),\n",
       " ('朗特产品经理', 1),\n",
       " ('中级产品经理', 1),\n",
       " ('', 1),\n",
       " ('高级WMS产品经理 ', 1)]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 列表推导式\n",
    "PM_title_words = [(  df_job_title.index.tolist()[i]   ,   df_job_title.values.tolist()[i]  )    for i in range(1,len(df_job_title.index.tolist())) ]\n",
    "PM_title_words"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "5fdc7416",
   "metadata": {},
   "source": [
    "# 相关岗位的平均薪资"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "f00bc79a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>平均薪资</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>job.title</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>产品经理</th>\n",
       "      <td>24.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>助理产品经理</th>\n",
       "      <td>17.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>医药产品经理</th>\n",
       "      <td>19.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>软件产品经理</th>\n",
       "      <td>25.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>高级产品经理</th>\n",
       "      <td>25.00</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            平均薪资\n",
       "job.title       \n",
       "产品经理       24.40\n",
       "助理产品经理     17.25\n",
       "医药产品经理     19.00\n",
       "软件产品经理     25.00\n",
       "高级产品经理     25.00"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 先统计每个job.title的数量\n",
    "job_title_counts = 非薪资面议['job.title'].value_counts()\n",
    "\n",
    "# 获取数量前五的job.title\n",
    "top_5_job_titles = job_title_counts.head(5).index.fillna('')\n",
    "\n",
    "# 根据数量前五的job.title筛选数据\n",
    "分岗位_平均薪资 = 非薪资面议[非薪资面议['job.title'].isin(top_5_job_titles)].groupby('job.title').agg({'平均薪资':'median'})\n",
    "\n",
    "分岗位_平均薪资\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "0806497b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[24.4, 17.2, 19.0, 25.0, 25.0]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "分岗位_平均薪资_values = [round(i[0], 1) for i in 分岗位_平均薪资.values.tolist()]\n",
    "分岗位_平均薪资_values\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "d6f09ed2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['产品经理', '助理产品经理', '医药产品经理', '软件产品经理', '高级产品经理']"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "分岗位_平均薪资_index = 分岗位_平均薪资.index.tolist()\n",
    "分岗位_平均薪资_index"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "46534f18",
   "metadata": {},
   "source": [
    "# 饼图"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "058a213d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>平均薪资</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>comp.compScale</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1-49人</th>\n",
       "      <td>20.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100-499人</th>\n",
       "      <td>24.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1000-2000人</th>\n",
       "      <td>23.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10000人以上</th>\n",
       "      <td>24.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2000-5000人</th>\n",
       "      <td>22.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50-99人</th>\n",
       "      <td>20.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>500-999人</th>\n",
       "      <td>25.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5000-10000人</th>\n",
       "      <td>32.50</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 平均薪资\n",
       "comp.compScale       \n",
       "1-49人           20.00\n",
       "100-499人        24.00\n",
       "1000-2000人      23.75\n",
       "10000人以上        24.40\n",
       "2000-5000人      22.50\n",
       "50-99人          20.00\n",
       "500-999人        25.00\n",
       "5000-10000人     32.50"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 首先去除'comp.compScale'中没有文字的行\n",
    "非薪资面议 = 非薪资面议[非薪资面议['comp.compScale'].str.strip() != '']\n",
    "\n",
    "\n",
    "# 先统计每个job.title的数量\n",
    "job_title_counts = 非薪资面议['comp.compScale'].value_counts()\n",
    "\n",
    "# 获取数量前五的job.title\n",
    "top_5_job_titles = job_title_counts.head(9).index\n",
    "\n",
    "# 根据数量前五的job.title筛选数据\n",
    "公司规模 = 非薪资面议[非薪资面议['comp.compScale'].isin(top_5_job_titles)].groupby('comp.compScale').agg({'平均薪资':'median'})\n",
    "公司规模\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "53e69832",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[20.0, 24.0, 23.8, 24.4, 22.5, 20.0, 25.0, 32.5]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "公司规模_薪资 = [round(i[0], 1) for i in 公司规模.values.tolist()]\n",
    "公司规模_薪资\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "f9f1390a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['1-49人',\n",
       " '100-499人',\n",
       " '1000-2000人',\n",
       " '10000人以上',\n",
       " '2000-5000人',\n",
       " '50-99人',\n",
       " '500-999人',\n",
       " '5000-10000人']"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "公司规模_人数 = 公司规模.index.tolist()\n",
    "公司规模_人数"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "ce3537bb",
   "metadata": {},
   "outputs": [],
   "source": [
    "maps = (\n",
    "    Map()\n",
    "    .add(\"岗位数量\", [list(z) for z in zip(地区, 岗位个数)],城市)\n",
    "    .set_global_opts(\n",
    "        title_opts=opts.TitleOpts(title=城市+关键词+\"的分布地图\"), visualmap_opts=opts.VisualMapOpts()\n",
    "    )\n",
    "    #.render( 城市+关键词+\"地区分布\"+\".html\")\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "53d12091",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pyecharts.options as opts\n",
    "from pyecharts.charts import Line\n",
    "from pyecharts.commons.utils import JsCode\n",
    "\n",
    "\n",
    "\n",
    "background_color_js = (\n",
    "    \"new echarts.graphic.LinearGradient(0, 0, 0, 1, \"\n",
    "    \"[{offset: 0, color: '#c86589'}, {offset: 1, color: '#06a7ff'}], false)\"\n",
    ")\n",
    "area_color_js = (\n",
    "    \"new echarts.graphic.LinearGradient(0, 0, 0, 1, \"\n",
    "    \"[{offset: 0, color: '#eb64fb'}, {offset: 1, color: '#3fbbff0d'}], false)\"\n",
    ")\n",
    "\n",
    "line = (\n",
    "    Line(init_opts=opts.InitOpts(bg_color=JsCode(background_color_js)))\n",
    "    .add_xaxis(xaxis_data=分年限_平均薪资_index)  # 设置x轴数据为分年限_平均薪资_index\n",
    "    .add_yaxis(\n",
    "        series_name=\"薪资\",\n",
    "        y_axis=分年限_平均薪资_values,  # 设置y轴数据为分年限_平均薪资_values\n",
    "        is_smooth=True,\n",
    "        is_symbol_show=True,\n",
    "        symbol=\"circle\",\n",
    "        symbol_size=6,\n",
    "        linestyle_opts=opts.LineStyleOpts(color=\"#fff\"),\n",
    "        label_opts=opts.LabelOpts(is_show=True, position=\"top\", color=\"white\"),\n",
    "        itemstyle_opts=opts.ItemStyleOpts(\n",
    "            color=\"red\", border_color=\"#fff\", border_width=3\n",
    "        ),\n",
    "        tooltip_opts=opts.TooltipOpts(is_show=False),\n",
    "        areastyle_opts=opts.AreaStyleOpts(color=JsCode(area_color_js), opacity=1),\n",
    "    )\n",
    "    .set_global_opts(\n",
    "        title_opts=opts.TitleOpts(\n",
    "            title=城市+关键词+\"从业年限平均薪资\",\n",
    "            pos_left=\"5%\",  # 将标题移到左上角\n",
    "            pos_top=\"5%\",  # 将标题移到左上角\n",
    "            title_textstyle_opts=opts.TextStyleOpts(color=\"#fff\", font_size=16),\n",
    "        ),\n",
    "        xaxis_opts=opts.AxisOpts(\n",
    "            type_=\"category\",\n",
    "            boundary_gap=False,\n",
    "            axislabel_opts=opts.LabelOpts(margin=30, color=\"#ffffff63\"),\n",
    "            axisline_opts=opts.AxisLineOpts(is_show=False),\n",
    "            axistick_opts=opts.AxisTickOpts(\n",
    "                is_show=True,\n",
    "                length=25,\n",
    "                linestyle_opts=opts.LineStyleOpts(color=\"#ffffff1f\"),\n",
    "            ),\n",
    "            splitline_opts=opts.SplitLineOpts(\n",
    "                is_show=True, linestyle_opts=opts.LineStyleOpts(color=\"#ffffff1f\")\n",
    "            ),\n",
    "        ),\n",
    "        yaxis_opts=opts.AxisOpts(\n",
    "            type_=\"value\",\n",
    "            position=\"right\",\n",
    "            axislabel_opts=opts.LabelOpts(margin=20, color=\"#ffffff63\"),\n",
    "            axisline_opts=opts.AxisLineOpts(\n",
    "                linestyle_opts=opts.LineStyleOpts(width=2, color=\"#fff\")\n",
    "            ),\n",
    "            axistick_opts=opts.AxisTickOpts(\n",
    "                is_show=True,\n",
    "                length=15,\n",
    "                linestyle_opts=opts.LineStyleOpts(color=\"#ffffff1f\"),\n",
    "            ),\n",
    "            splitline_opts=opts.SplitLineOpts(\n",
    "                is_show=True, linestyle_opts=opts.LineStyleOpts(color=\"#ffffff1f\")\n",
    "            ),\n",
    "        ),\n",
    "        legend_opts=opts.LegendOpts(is_show=False),\n",
    "    )\n",
    "    #.render(\"从业年限平均薪资.html\")\n",
    "\n",
    ")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "928eb2ff",
   "metadata": {},
   "outputs": [],
   "source": [
    "from pyecharts import options as opts\n",
    "from pyecharts.charts import WordCloud,Grid\n",
    "from pyecharts.globals import SymbolType\n",
    "\n",
    "worlds = (\n",
    "    WordCloud()\n",
    "    .add(\"\", PM_title_words, word_size_range=[20, 100], shape=SymbolType.DIAMOND)\n",
    "    .set_global_opts(title_opts=opts.TitleOpts(title=\"岗位名称词云图\"))\n",
    "    .render( 关键词 +\"_wordcloud_map_岗位名称_\"+\".html\")\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "id": "28a968c9",
   "metadata": {},
   "outputs": [],
   "source": [
    "from pyecharts import options as opts\n",
    "from pyecharts.charts import Bar\n",
    "from pyecharts.commons.utils import JsCode\n",
    "from pyecharts.faker import Faker\n",
    "\n",
    "background_color_js = (\n",
    "    \"new echarts.graphic.LinearGradient(0, 0, 0, 1, \"\n",
    "    \"[{offset: 0, color: '#c86589'}, {offset: 1, color: '#06a7ff'}], false)\"\n",
    ")\n",
    "\n",
    "bar = (\n",
    "    Bar()\n",
    "    .add_xaxis(分岗位_平均薪资_index)\n",
    "    .add_yaxis(关键词, 分岗位_平均薪资_values, category_gap=\"70%\")\n",
    "    .set_series_opts(\n",
    "        itemstyle_opts={\n",
    "            \"normal\": {\n",
    "                \"color\": JsCode(background_color_js),\n",
    "                \"barBorderRadius\": [30, 30, 30, 30],\n",
    "                \"shadowColor\": \"rgb(0, 160, 221)\",\n",
    "            }\n",
    "        }\n",
    "    )\n",
    "    .set_global_opts(title_opts=opts.TitleOpts(title=\"相关岗位平均薪资\"),\n",
    "                    xaxis_opts=opts.AxisOpts(axislabel_opts=opts.LabelOpts(rotate=-15))\n",
    "                    )\n",
    "    #.render(\"相关岗位平均薪资.html\")\n",
    ")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "ce06fe4e",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pyecharts.options as opts\n",
    "from pyecharts.charts import Pie, Tab\n",
    "\n",
    "\"\"\"\n",
    "Gallery 使用 pyecharts 1.1.0\n",
    "参考地址: https://echarts.apache.org/examples/editor.html?c=pie-doughnut\n",
    "\n",
    "目前无法实现的功能:\n",
    "\n",
    "1、迷之颜色映射的问题\n",
    "\"\"\"\n",
    "\n",
    "x_data = 公司规模_人数\n",
    "y_data = 公司规模_薪资\n",
    "data_pair = [list(z) for z in zip(x_data, y_data)]\n",
    "data_pair.sort(key=lambda x: x[1])\n",
    "\n",
    "pies=(\n",
    "    Pie(init_opts=opts.InitOpts(bg_color=\"#2c343c\"))\n",
    "    .add(\n",
    "        series_name=\"薪资\",\n",
    "        data_pair=data_pair,\n",
    "        rosetype=\"radius\",\n",
    "        radius=\"55%\",\n",
    "        center=[\"50%\", \"50%\"],\n",
    "        label_opts=opts.LabelOpts(is_show=False, position=\"center\"),\n",
    "    )\n",
    "    .set_global_opts(\n",
    "        title_opts=opts.TitleOpts(\n",
    "            title=城市+关键词+\"的\"+\"各公司规模薪资\",\n",
    "            pos_left=\"center\",\n",
    "            pos_top=\"20\",\n",
    "            title_textstyle_opts=opts.TextStyleOpts(color=\"#fff\"),\n",
    "        ),\n",
    "        legend_opts=opts.LegendOpts(is_show=False),\n",
    "    )\n",
    "    .set_series_opts(\n",
    "        tooltip_opts=opts.TooltipOpts(\n",
    "            trigger=\"item\", formatter=\"{a} <br/>{b}: {c} ({d}%)\"\n",
    "        ),\n",
    "        label_opts=opts.LabelOpts(color=\"rgba(255, 255, 255, 0.3)\"),\n",
    "    )\n",
    "    #.render(\"饼图.html\")\n",
    ")\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "a482e1bc",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.12"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {},
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {
    "height": "calc(100% - 180px)",
    "left": "10px",
    "top": "150px",
    "width": "240.667px"
   },
   "toc_section_display": true,
   "toc_window_display": true
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
